Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: SELECTing f...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 8 Topic 16851 of 17269
Post > Topic >>

Re: SELECTing from a DML statement

by "gym dot scuba dot kennedy at gmail" <kennedyii@[EMAIL PROTECTED] > Jul 4, 2008 at 10:35 AM

"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
 




 8 Posts in Topic:
SELECTing from a DML statement
jefftyzzer <jefftyzzer  2008-07-03 15:57:12 
Re: SELECTing from a DML statement
"gym dot scuba dot k  2008-07-04 02:26:17 
Re: SELECTing from a DML statement
"Shakespeare" &  2008-07-04 09:34:04 
Re: SELECTing from a DML statement
Jeroen van den Broek <  2008-07-04 03:23:06 
Re: SELECTing from a DML statement
"gym dot scuba dot k  2008-07-04 10:35:34 
Re: SELECTing from a DML statement
Serge Rielau <srielau@  2008-07-04 09:44:18 
Re: SELECTing from a DML statement
Jeroen van den Broek <  2008-07-04 09:26:04 
Re: SELECTing from a DML statement
"Vladimir M. Zakhary  2008-07-04 11:57:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 20:09:00 CDT 2008.