Re: select/insert/delete

I saw merge was suggested, but without mentioning that merge actually can do
deletes as well in recent versions...

I haven't tested it, but what if you merge into a view that joins you
table_a and table_b together. Then it might fulfill your 3 statements in 1
go.

Stefan


=========================

Stefan P Knecht
CEO & Founder
s@xxxxxxxx

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch

=========================


On Wed, Jun 8, 2011 at 1:12 AM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote:

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

Other related posts: