Message-Id: <10495.105539@fatcity.com> From: "Ruth Gramolini" Date: Fri, 12 May 2000 13:30:11 -0400 Subject: Re: How to delete from one table based on a multiple table query If you can retrieve the records with a select statement and get the right ones they you can replace the select * from table_name with a delete table name. If you can't get the select statement to retrieve the correct records then refine your select statement until you are able to select * from table_name where and get the right record set then replace then you will be able to delete the correct records. HTH Ruth. ----- Original Message ----- From: Atish Prasad Das To: Multiple recipients of list ORACLE-L Sent: Friday, May 12, 2000 12:48 PM Subject: Re: How to delete from one table based on a multiple table query > i can't see a reason, why can't u do that using a straight forward delete > where stmt!!! > > ----- Original Message ----- > To: Multiple recipients of list ORACLE-L > Sent: Friday, May 12, 2000 8:47 PM > > > > I am trying to delete from a single table those records that > > match the results from a query joining several tables. This does > > not seem to work properly using a where exists statement. Does anyone > > have an alternative way of handling this? > > > > Thanks, > > Christian > > -- > > Author: Christian Carollo > > INET: CCarollo@viva.com > > > > 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@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). > > > > -- > Author: Atish Prasad Das > INET: atish.das@wipro.com > > 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@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).