Prev: ASM I/O size
Next: Fresh Enterprise Manager Install Can't connect "Connection Closed"
From: jefftyzzer on 3 Jul 2008 18:57
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
From: gym dot scuba dot kennedy at gmail on 3 Jul 2008 22:26

"jefftyzzer" <jefftyzzer(a)sbcglobal.net> wrote in message
news:055ecdf2-3c0a-4ea0-9dd1-9f52ab4deab1(a)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


From: Shakespeare on 4 Jul 2008 03:34

"jefftyzzer" <jefftyzzer(a)sbcglobal.net> schreef in bericht
news:055ecdf2-3c0a-4ea0-9dd1-9f52ab4deab1(a)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


From: Jeroen van den Broek on 4 Jul 2008 06:23
On Jul 4, 4:26 am, "gym dot scuba dot kennedy at gmail"
<kenned...(a)verizon.net> wrote:
> "jefftyzzer" <jefftyz...(a)sbcglobal.net> wrote in message
>
> news:055ecdf2-3c0a-4ea0-9dd1-9f52ab4deab1(a)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
From: gym dot scuba dot kennedy at gmail on 4 Jul 2008 06:35

"Jeroen van den Broek" <nltaal(a)baasbovenbaas.demon.nl> wrote in message
news:d04abf4a-da82-4c03-a6ea-cb2a967d2cfd(a)r66g2000hsg.googlegroups.com...
On Jul 4, 4:26 am, "gym dot scuba dot kennedy at gmail"
<kenned...(a)verizon.net> wrote:
> "jefftyzzer" <jefftyz...(a)sbcglobal.net> wrote in message
>
> news:055ecdf2-3c0a-4ea0-9dd1-9f52ab4deab1(a)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

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


 |  Next  |  Last
Pages: 1 2
Prev: ASM I/O size
Next: Fresh Enterprise Manager Install Can't connect "Connection Closed"