SELECTing from a DML statement

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
Received on Thu Jul 03 2008 - 17:57:12 CDT