establishing commit-rollback mechanism in a transaction

Hi,

If there are more than one tables that records to be inserted into and more then one record for some tables, is it possible to establish commit rollback mechanism?

It must be used repeater action for some tables because of more than one records to be inserted.

I'm trying to establish commit rollback mechanism for all inserts for oracle database.

Is it possible?

Thanks.