Is it possible to nest transactions?

Hi all,

Coming from a Sybase (SQLA) background, I would like to know, whether it is possible to nest transactions. Also, is there a command you can issue to explicitly tell Oracle you want to start a transaction? (Sort of like in SQLA "BEGIN TRANSACTION")
If nested transactions are possible, does Oracle keep a variable of some sort (one that you can hopefully query) on the transaction nesting depth?

I am searching the doco, but no mention of nested transactions.

While I am at it, is there an engine option you can set to tell Oracle to AUTOCOMMIT after DML statements?

Any help is much appreciated.

Regards

Csaba Toth

--
Csaba Toth
Programmer [Development]
csaba_at_addease.com.au

Addease Pty. Ltd.
P.O. Box 1484
COLLINGWOOD VIC 3066
Australia

Ph : +61 3 9416 2944
Fax: +61 3 9416 2580
web: http://www.addease.com.au