RE: how to identify table dublicates just using rowid ?

From: Ahmed Gholam Hussain <ahussain_at_gisqatar.org.qa>
Date: Sat, 01 Mar 2003 03:00:01 -0800
Message-ID: <F001.0055DBE0.20030301030001@fatcity.com>

Hi Salah ,  

This is a sample query on how to identify the duplicate rows : Select FROM tablename
WHERE rowid not in (SELECT MIN(rowid)
FROM tablename
GROUP BY column1, column2, column3...);  

Hope it helps….    

---

       

-----Original Message-----
Sent: Saturday, March 01, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L  

hi all,
how to identify or list table dublicates just using rowid ? Regards,
Salaheldin Aboali

---

Senior Software Developer
Management Information Systems
 <http://www.mis-kuwait.com> http://www.mis-kuwait.com Phone:
+965.240.64.25
+965.240.67.98
+965.240.80.92

Ext. 235
Fax. +965.240.81.53
Cell. +965.790.31.65

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ahmed Gholam Hussain
  INET: ahussain_at_gisqatar.org.qa

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Mar 01 2003 - 05:00:01 CST