What is the option

[Ralph]

I know about Rollback.Is there any other option or clause that can be used along with Rollback.

[sammy]

You can use the following option or clause with rollback.

rollback to savepoint savepoint_name;
rollback force force_name;

A rollback undoes all changes in the database that were done in the current transaction. Rollback with savepoint undoes all changes till the savepoint.