RE: Hi need some please

From: Brian MacLean <bmaclean_at_vcommerce.com>
Date: Fri, 18 May 2001 14:54:32 -0700
Message-ID: <F001.00308605.20010518150148@fatcity.com>

Is what your trying to do as simple as?...

delete from TAB_B B

 where exists (select 'x'
                 from TAB_A A
                where A.col1 = B.col1
                  and A.col2 = B.col2
                  and A.etc  = B.etc
              );

-----Original Message-----
From: Bill Conner [mailto:bconner_at_verio.net] Sent: Friday, May 18, 2001 11:42 AM
To: Multiple recipients of list ORACLE-L Subject: Hi need some please

Hi All,

Does anyone have a script that will compare table_a to table_b and delete the dups in table_b,  or a site that might have one?

Thanks Very Much for any ideas.

                -bill

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bill Conner
  INET: bconner_at_verio.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Fri May 18 2001 - 16:54:32 CDT