The interactions in this eCourse require Javascript to be enabled.
Saving and Discarding Changes
previous|next
In Oracle Database Express Edition, transactional SQL commands are enabled for the Application Express instance by using the Autocommit check box that appears on the SQL Commands home page. To disable transactional SQL commands, select the Autocommit check box. If you use any transactional SQL commands (such as COMMIT or ROLLBACK) when in transactional mode, an error message is returned To enable transactional SQL commands, clear the Autocommit check box. Application Express verifies that the necessary system resources are available before entering the transactional mode. If resources are unavailable, an error message is displayed. The following behavior is implicit in transactional mode:
Actions are not committed to the database until you enter an explicit COMMIT command.
Exiting SQL Commands terminates and rolls back the current transaction.