Example 1: Setting the QUIET COMMIT Option On and Off SQL> COMMIT; %SQL-F-NO_TXNOUT, No transaction outstanding SQL> SET QUIET COMMIT 'ON'; SQL> ROLLBACK; SQL> SET QUIET COMMIT 'OFF'; SQL> ROLLBACK; %SQL-F-NO_TXNOUT, No transaction outstanding