Re: SELECTing from a DML statement

"jefftyzzer" <jefftyzzer_at_sbcglobal.net> schreef in bericht news:055ecdf2-3c0a-4ea0-9dd1-9f52ab4deab1_at_j33g2000pri.googlegroups.com...
> DB2 allows one to select from an insert, update, or delete, e.g.:
>
> select * from old table (delete from x where y = 1);
>
> --OR--
>
> select * from new table (update x set y = 1 where z = 2);
>
> --OR--
>
> select * from final table (insert into x (c1) values (1));
>
> Is there any equivalent in Oracle?
>
> Thanks and regards,
>
> --Jeff

I guess you mean something like delete from x where exists (select y from z where v=w)
Shakespeare Received on Fri Jul 04 2008 - 02:34:04 CDT