Column value restriction

[Manuel G]

Hi all:

Is there any way to restrict a table column to a group of values?

Example: I want column values to be 0 or 1 and any more, and I want Oracle to give an error if this clause is violated.

Thanks in advance.

[Ian Lochray · Accepted solution]

When you create or alter your table, you can give a column a "check constraint". For example:
create table abc (col1 NUMBER CONSTRAINT check_col1 CHECK(col1 BETWEEN 0 AND 1));

[Steve Lewis]

SVRMGR> create table sjl ( i integer check (i in (0,1)));
Statement processed.
SVRMGR> insert into sjl values (2);
ORA-02290: check constraint (SYS.SYS_C0035076) violated
SVRMGR> insert into sjl values (0);
1 row processed.