select/insert/delete

From: Michael Moore <michaeljmoore@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 7 Jun 2011 16:12:49 -0700

I think the answer to this is NO, but just to be sure,

Is there a single SQL statement that can:

1) SELECT row-X from table A
2) INSERT row-X into table B
3) DELETE row-X from table A

It would be nice to be able to do this without a context switch.

Regards,
Mike

Follow-Ups:
- Re: select/insert/delete
  - From: David Litchfield
- Re: select/insert/delete
  - From: Stefan Knecht
- Re: select/insert/delete
  - From: Timo Raitalaakso
- Re: select/insert/delete
  - From: Jonathan Lewis

Other related posts:

» select/insert/delete - Michael Moore
» Re: select/insert/delete- David Litchfield
» Re: select/insert/delete- David Litchfield
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Robert Freeman
» Re: select/insert/delete- Robert Freeman
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Robert Freeman
» Re: select/insert/delete- Robert Freeman
» Re: select/insert/delete- Stefan Knecht
» Re: select/insert/delete- Timo Raitalaakso
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Jonathan Lewis
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Adam Musch
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Timo Raitalaakso
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Robert Freeman
» Re: select/insert/delete- Michael Moore
» Re: select/insert/delete- Remigiusz Sokolowski