under-transaction ?

From: CM <le-spam-je-dis-non_at_ulg.ac.be>
Date: Fri, 20 Feb 2004 16:05:47 +0100
Message-ID: <c157o9$k02@aix4.segi.ulg.ac.be>

Hello,

Is it possible to create a transaction in a transaction?

BEGIN T1 INSERT into t1 values(2);

BEGIN T2 INSERT into t1 values(3);

ROLLBACK T2 COMMIT T1 I will have liked that the "ROLLBACK" of the T2 transaction does not disturb the "INSERT" made in the principal transaction. If that exists, which are commands SQL for Oracle 9i? Thank you very much. (And excuse me for my imperfect English)

Christophe Received on Fri Feb 20 2004 - 09:05:47 CST