• 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.


Other related posts: