Add Check Constraint Error
Hi all,
I had encounter below error when I trying to add check constraint in my existing table. Any ideal to get rid of the error?
thanz in advance.
SQL> l
1 alter table table1 add contraint
2* chk_1 check (col1 in ('Y','N'))
SQL> /
chk_ 1 check (col1 in ('Y','N'))
*
ERROR at line 2:
ORA-02438: Column check constraint cannot reference other columns
Re: Add Check Constraint Error
Quote:
Originally posted by samc
Column check constraint cannot reference other columns
Yes, that is the answer.