Re: SELECTing from a DML statement

On Jul 4, 4:26 am, "gym dot scuba dot kennedy at gmail" <kenned..._at_verizon.net> wrote:
> "jefftyzzer" <jefftyz..._at_sbcglobal.net> wrote in message
>
> 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 am trying to figure out what your examples mean.
> Jim- Hide quoted text -
>
> - Show quoted text -

http://it.toolbox.com/blogs/db2luw/selecting-from-an-insert-update-delete-statement-7239 and:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0411rielau/

HTH

--
Jeroen