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.
1 alter table table1 add contraint
2* chk_1 check (col1 in ('Y','N'))
chk_ 1 check (col1 in ('Y','N'))
ERROR at line 2:
ORA-02438: Column check constraint cannot reference other columns