Uniqueness

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Tue, 17 May 2005 23:12:03 -0700 (PDT)
Message-ID: <20050518061204.42089.qmail@web52902.mail.yahoo.com>

Hi again,

Is there a way to check for uniqueness of a value ? Apart from set the column to be unique ?

For example :

Table : mytbl
PK ID

---

1
2
3

Insert into mytbl (id) values (2);  

Oracle will give error.

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l Received on Wed May 18 2005 - 02:16:42 CDT