I am aware that we can put bunch of database transactions like 'insert'/'update/delete between begin and commit and in the catch block depending on the seriousness of the error that occured we can rollback.

Is that the right scenario to use sqltransaction class?

Is there any equivalent class for oracle database?

thanks
nath