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!

Unique constraint spanning multiple tables

335489Jan 15 2007 — edited Jan 15 2007

I'm using oracle 10g. I would like to know if there is a way to create unique constraint spanning multiple tables?

As an example,

I've 2 tables. One called ORDER(id, name) and other one called DEVICE (id, name)....My program inserts values into both ORDER and DEVICE at the same time....I want the database to disallow same values in the combination of ORDER and DEVICE.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2007

Added on Jan 15 2007

7 comments

1,977 views