RE: Uniqueness

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 18 May 2005 08:00:59 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E5E7@EXCNYSM0A1AJ.nysemail.nyenet>

You can also:

Select id, count(*)
>From mytbl

Group by id
Having count(*) > 1
/

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kean Jacinta Sent: Wednesday, May 18, 2005 2:12 AM
To: oracle-l_at_freelists.org
Subject: Uniqueness

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);
=20
Oracle will give error.=20

---

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

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 18 2005 - 08:05:58 CDT