under-transaction ?

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 - 16:05:47 CET