topic Re: Column value restriction in Operating System - HP-UX

Column value restriction

Manuel G — Wed, 26 Jun 2002 07:36:29 GMT

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.

Re: Column value restriction

Ian Lochray — Wed, 26 Jun 2002 08:10:55 GMT

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));

Re: Column value restriction

Steve Lewis — Wed, 26 Jun 2002 08:16:49 GMT

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.