Overriding default locking, PL-SQL Programming

Overriding Default Locking

By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to your benefits to override the default locking. The Explicit locking share or deny access to the table for the period of a transaction.

With the LOCK TABLE statement, you can explicitly lock the whole table. With the SELECT FOR UPDATE statement, you can explicitly lock the specific rows of a table to make sure that they do not change before an update or delete is executed. Though, the Oracle automatically obtains the row-level locks at update or deletes time. Therefore, use the FOR UPDATE clause only if you want to lock the rows before the update or delete.

Posted Date: 10/4/2012 5:20:05 AM | Location : United States







Related Discussions:- Overriding default locking, Assignment Help, Ask Question on Overriding default locking, Get Answer, Expert's Help, Overriding default locking Discussions

Write discussion on Overriding default locking
Your posts are moderated
Related Questions
Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

LIKE Operator You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns mat

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

CURRVAL and NEXTVAL The series is a schema object which generates the sequential numbers. Whenever you form a sequence, you can specify its primary value and an increment. T

Using Aliases The Select-list items fetched from a cursor related with the %ROWTYPE should have simple names or, if they are expressions, should have aliases. In the example bel

Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor