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

Home -> Community -> Usenet -> c.d.o.server -> Query to find non-unique records

Query to find non-unique records

From: ewong <ewong_at_ewong.com>
Date: Wed, 25 Apr 2001 20:58:09 GMT
Message-ID: <3AE73AAA.D72BE84@ewong.com> 






I have a table:


id    integer,


tag1    varchar2(5),


tag2    varchar2(5),


text     clob


...



The primary key is (id,tag1,tag2).  I disabled the pk couple days ago
and find that I am not able to enable it anymore because some new
records don't have unique pks on the three columns.  How can I do query
to track down those non-unique records?



Thanks.
Received on Wed Apr 25 2001 - 15:58:09 CDT












Original text of this message













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