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 to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ

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

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

%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:

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must