Re: SELECTing from a DML statement
From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Fri, 04 Jul 2008 02:26:17 GMT
Message-ID: <dTfbk.202$rb1.123@trndny08>
Date: Fri, 04 Jul 2008 02:26:17 GMT
Message-ID: <dTfbk.202$rb1.123@trndny08>
"jefftyzzer" <jefftyzzer_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
Received on Thu Jul 03 2008 - 21:26:17 CDT