Skip to Main Content

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!

Avoid duplicate record without primary key/unique key

508936Nov 8 2006 — edited Nov 10 2006
Hi,

I created a table, TEST. My requirement is, The table should not allow duplicate rows with out adding primary key/unique key to any of the columns.

Any way is there without using a TRIGGER or SCHEDULER?

regrads
Mathew
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2006
Added on Nov 8 2006
17 comments
1,898 views