Re: How to determine uniqueness in PL/SQL

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 13 May 1999 09:44:05 -0400
Message-ID: <7hekr1$27r$1@autumn.news.rcn.net>

Hi Ruiping,

Please clarify your question. The reason I say this is that if you have defined a primary key for a table Oracle will not allow a duplicate to be added. That being the case there is nothing you will have to do in order to prevent duplicates from being added to a table with a primary key.

regards

Jerry Gitomer

Ruiping Gao wrote in message <373A5B87.D6D2A087_at_dpiwe.tas.gov.au>...
>I have a table which has combination of columns as the table's primary
>key. When ever people want to insert records into table, I would like
>create a trigger to check if it is duplicated records according to my
>combination primary key. If it's duplicated records, the system will
>refuse to accept the records, otherwise the new records can be in. But I
>don't know how to do it? Please help.
>
>Thanks in advance
>
>Ruiping
>
>e_mail:ruiping_at_dpiwe.tas.gov.au
>
>
Received on Thu May 13 1999 - 08:44:05 CDT