Home » SQL & PL/SQL » SQL & PL/SQL » no same values in same field (putting aside primary key solve)
icon4.gif  no same values in same field [message #284762] Fri, 30 November 2007 18:44 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I want to build table with constraint prevent specific field from duplicate his values .... I don't want that constraint be primary key , I want any constraint else to make what i want.
Re: no same values in same field [message #284763 is a reply to message #284762] Fri, 30 November 2007 18:54 Go to previous message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
create a UNIQUE index on that column
Previous Topic: plsql table...pls help..really urgent
Next Topic: Unwanted "object owner" in procedure causing ORA-04052 error
Goto Forum:

Current Time: Sat Aug 19 21:24:17 CDT 2017

Total time taken to generate the page: 0.22423 seconds