select/insert/delete

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Tue, 7 Jun 2011 16:12:49 -0700
Message-ID: <BANLkTimKryAHh_u8nj_-+Sxink_BC2UKZg_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 07 2011 - 18:12:49 CDT