Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to determine uniqueness in PL/SQL

How to determine uniqueness in PL/SQL

From: Ruiping Gao <ruiping_at_dpiwe.tas.gov.au>
Date: Thu, 13 May 1999 15:56:40 +1100
Message-ID: <373A5B87.D6D2A087@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 Wed May 12 1999 - 23:56:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US