Selecting from and updating the same table oracle a good head line for a dating site

Locks can be acquired at both the table and sub-partition level with partitioned tables in Oracle.A transaction acquires a table lock when a table is modified in the following DML statements: INSERT, UPDATE, DELETE, SELECT with the FOR UPDATE clause, and LOCK TABLE.


to allow inserting and updating exactly the desired data.There is no hard limit on the exact number of row locks held by a statement or transaction.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>