Re: SELECTing from a DML statement

"Jeroen van den Broek" <nltaal@[EMAIL PROTECTED]
> wrote in message 
news:d04abf4a-da82-4c03-a6ea-cb2a967d2cfd@[EMAIL PROTECTED]
 Jul 4, 4:26 am, "gym dot scuba dot kennedy at gmail"
<kenned...@[EMAIL PROTECTED]
> wrote:
> "jefftyzzer" <jefftyz...@[EMAIL PROTECTED]
> wrote in message
>
>
news:055ecdf2-3c0a-4ea0-9dd1-9f52ab4deab1@[EMAIL PROTECTED]
>
>
>
> > 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

Look up returning
eg insert into ... returning ...;
JIm