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).
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).
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).