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 -> Listing of non distinct rows

Listing of non distinct rows

From: Scott Nutter <scott.nutter_at_pmcsystems.com>
Date: 19 Jul 2001 08:12:25 -0700
Message-ID: <76e6d6e.0107190712.76f49403@posting.google.com> 






I have a table that has a unique constraint on 4 coulmns.  I want to
change it to use only 3 columns as a unique constraint, however I want
a listing of the rows that will now be duplicates.  Any ideas as to
how to get a listing of rows that are not distinct?



Thanks
Received on Thu Jul 19 2001 - 10:12:25 CDT












Original text of this message













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