How to restrict the length of INTEGER when creating a table in ORACLE?

Question

all

When creating a table in Oracle sql*plus, I want to restrict that the length of an INTEGER column can only be 8.

eg: the RegNumber is an INTEGER, and it must be a 8 digit number.

How can I do this when I creating a table?

Answer 1

The INTEGER datatype is just a subtype of NUMBER. You can define the column as NUMBER(8,0) to get you an integer column that is <= 8 digits.

If you are trying to ensure that the column is 8 digits and ONLY 8 digits, you'll need to add a check constraint on the column:

CREATE TABLE RegTable
(RegNumber NUMBER(8,0),
CONSTRAINT CheckRegNumber  CHECK (RegNumber > 9999999)
);