SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

check constraint for two columns

258965Aug 16 2005 — edited Aug 16 2005

Hi

I have a table like this structure:

test
col1 col2

then I'd like inseert into this table when col1 & col2 are null and if one of the is full (col1) I don't have ability to insert the other column(col2) then never both of them full.

How can I do this logic with check constraint?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2005

Added on Aug 16 2005

6 comments

1,412 views