RE: Hi need some please
hi bill, Why cann't you try with 'MINUS' set operator exists in sql?. Select * from table_b minus Select * from table_a Hope that this will help you. Nirmal. > -Original Message- > From: Christopher Spence [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, May 20, 2001 7:46 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Hi need some please > > Depending if you mean rows or individual columns but this shouldnt' be to > difficult with PL/SQL. With SQL it will be a little more difficult but > doable. Unfortunately I don't know a site with this as I never had needed > to. > > > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 5/18/01 2:41 PM > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Christopher Spence > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Hi need some please
Depending if you mean rows or individual columns but this shouldnt' be to difficult with PL/SQL. With SQL it will be a little more difficult but doable. Unfortunately I don't know a site with this as I never had needed to. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/18/01 2:41 PM 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Hi need some please
Title: RE: Hi need some please 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).