DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004

    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

  2. #2
    Join Date
    Feb 2000

    Re: Add Check Constraint Error

    Originally posted by samc
    Column check constraint cannot reference other columns
    Yes, that is the answer.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Apr 2003
    May be the column not part of the table or column name typed wrong.

    SQL> create table kk ( no number(5));

    Table created.

    SQL> alter table kk add constraint xcv check (no in(1,2));

    Table altered.

  4. #4
    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!

  5. #5
    Join Date
    Feb 2004

    SQL> create table sjk (name varchar2(5));

    Table created.

    SQL> alter table sjk add constraint cs check (name in ('Y','N'));

    Table altered.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.