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
Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin

Transaction Visibility As the figure shows, the changes made by an autonomous transaction become visible to another transaction whenever the autonomous transaction commits. Th

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

THEO R Y OF ETERNITY OF LIFE (PRAYER - 1880) - The theory of eternity of life, also called the steady-state theory , states that life has ever been in existence as at presen

Using LOCK TABLE You use the LOCK TABLE statement to lock the whole database tables in the specified lock mode so that you can share or deny the access to them. For illustrati

Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i