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
Are you sure you really want check constraints? Personally I hate the damn things. Every time our developers add a new possible value to the code they then forget theres a check constrain and it sll stops working. Data-driven validation every time!