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
Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

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

Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause:

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam