Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> question on delete statement

question on delete statement

From: Fabio <nonce_at_nulla.it>
Date: Fri, 20 Jun 2003 08:03:48 GMT
Message-ID: <EdzIa.104026$Ny5.3014229@twister2.libero.it> 





Hi


I'm pretty new on Oracle so I'm sorry if this question was posted before.



How is the behaviour of the DB engine on a complex delete query (I'm working
on 9i)?



If I had a query like



delete (select * from A join B on A.f1=B.f1) C
where C.f3 = '???' and C.f4 = 0



which table (A or/and B) will be involved in the delete?
How could I know if I'm deleting records from A table or B table or both ?
Is there some syntax to specify the table I want delete records from?



Thanks in advance


Fabio
Received on Fri Jun 20 2003 - 03:03:48 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US