Transaction control, PL-SQL Programming

Transaction Control

The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manipulation statements that does a logical unit of work. For illustration, the two UPDATE statements might credit one bank account and debit another.

At the same time, the Oracle makes permanent or undoes all the database changes made by a transaction. If your program fails in the middle of the transaction, the Oracle detects the error and rolls back the transaction. Therefore, the database is restored to its previous state automatically.

You use the ROLLBACK, COMMIT, SAVEPOINT, & SET TRANSACTION commands to control the transactions. The COMMIT makes everlasting and any database changes made during the present transaction. The ROLLBACK ends the present transaction and undoes any changes made as the transaction began. The SAVEPOINT marks the present point in the processing of a transaction. Used with the ROLLBACK, SAVEPOINT undoes part of a transaction. The SET TRANSACTION sets the transaction properties like the read/write access and isolation level.

Posted Date: 10/4/2012 3:38:43 AM | Location : United States







Related Discussions:- Transaction control, Assignment Help, Ask Question on Transaction control, Get Answer, Expert's Help, Transaction control Discussions

Write discussion on Transaction control
Your posts are moderated
Related Questions
Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO

Recursive Subprograms The recursive subprogram is the one that calls itself. Think of a recursive call as a call to a few other subprograms that does the similar task as your

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Parameter and Keyword Description:   table_reference: This keyword identifies the table or view that should be accessible when you execute the UPDATE statement, and for wh

Use of COUNT in SQL It describes and discusses various general methods of expressing constraints, eventually noting that support for "=" with relation operands is sufficient f