col key-col2 noprint
...
col cnt noprint
which will just spool out the generated DELETE commands...
Be careful! Hope this helps...
-Tim
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 10:35 AM
Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
o.za>cc:
Sent by: Subject: removing duplicate
Hi List
Is there a tool for removing duplicate entries from a table - except that
the key field is not the same. I ran some data imports more than once and
was hoping someone could point me in the direction of a way to undo my
mistake.
Any help will be most appreciated
Thanks
Mark Warner