Oracle Database Discussions

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!

Primary key with optional column

petehugFeb 2 2004 — edited Feb 2 2004

I have a compound primary key (Constraint) consisting of 2 columns. The 1st column is mandatory (can't be NULL) but the 2nd column is optional. If I try inserting a record with the 2nd column being NULL, I get an error.

This is something that worked fine under SQL Server. How is the same effect achieved in Oracle?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2004

Added on Feb 2 2004

#general-database-discussions

5 comments

1,349 views