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: 24958
Registered: January 2009
Location: SoCal
Senior Member
create a UNIQUE index on that column
Previous Topic: remove duplicate rows in Hierarchical Queries
Next Topic: plsql table...pls help..really urgent
Goto Forum:

Current Time: Fri Oct 21 11:52:13 CDT 2016

Total time taken to generate the page: 0.08731 seconds