Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: delete from multiple tables?
It's recent.. I know it works in 9i, but not sure about 8i (don't have an 8i
instance to try it on). It absolutely did not work in 7.x.
"Thomas Kellerer" <spam_eater_at_gmx.net> wrote in message
news:bf9cia$8rs$1_at_svr8.m-online.net...
> JJ Reynolds schrieb:
> > or.. an even cuter syntax!
> >
> > delete from t1 where (col1, col2) in (select col1, col2 from t2);
> >
> >
> This is cool :)
>
> I didn't know that this is possible.
> After so many years of SQL experience one can still learn new things..
>
> Cheers
> Thomas
>
Received on Fri Jul 18 2003 - 13:25:57 CDT