Re: Nested transactions?

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/25
Message-ID: <32C1BD0C.54CE@qrcsun.qrc.org>#1/1

Mr. Jeremy Bettis wrote:
>
> Does Oracle have nested transactions? i.e. can I do something like this:
>
> start transaction
>
> insert foo...
>
> start transaction
>
> insert bar...
>
> rollback
>
> insert baz...
>
> commit

You can achieve this by using SAVEPOINT.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Wed Dec 25 1996 - 00:00:00 CST