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 -> Finding duplicate rows in a table

Finding duplicate rows in a table

From: chris <x_at_worldnet.att.net>
Date: 1997/09/08
Message-ID: <34142F08.768F@worldnet.att.net>#1/1 







I don't know how, but when I try and copy one of my tables to another
server across the net, I get a constraint violation on the primary key.
How can I find the rows in the original table that have duplicate
primary key information (the primay key consists of two columns).



chris
Received on Mon Sep 08 1997 - 00:00:00 CDT












Original text of this message













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