TransactionCreating Transactions and Committing New DataCommit and Roll Back in SQL*PlusSavepointsTransaction control commandsTransactionSen ZhangCreating Transactions and Committing New Data•Transaction: series of action queries that represent a logical unit of work•User can commit (save) changes•User can roll back (discard) changes•Pending transaction: a transaction waiting to be committed or rolled back•Oracle DBMS locks records associated with pending transactions•Other users cannot view or modify locked recordsCommit and Roll Back in SQL*Plus•Transactions begin automatically with first command•Type COMMIT to commit changes•Type ROLLBACK to roll back changesSavepoints•A bookmark that designates the beginning of an individual section of a transaction•Changes are rolled back to savepointTransaction control commands•Savepoint label•Rollback•Rollback to
View Full Document