Re: question on delete statement

Fabio wrote:

> 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

This is a homework question and one you should work out for yourself.

The best way ... build two tables, populate them with a bit of data, and try it.

BTW: Your syntax is incorrect.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)