Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Join or not ?
Why don't you perform an explain plan on it ... I'm pretty sure you'll find
a join in there :-)
"Etienne Massip" <moutonnoir_at_netcourrier.com> wrote in message
news:f033dea7.0203061201.bc2d086_at_posting.google.com...
> Hello,
>
> Could anyone say me if the following simple SQL query contains a join
> operation or not ?
>
> UPDATE T1 SET T1.C2=(SELECT T2.C2 FROM T2 WHERE T2.C1=T1.C1)
>
> IMHO the answer is no, but my colleagues disagree :)
>
> Thx a lot,
>
> Etienne Massip
Received on Wed Mar 06 2002 - 14:28:49 CST