SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NO LOCK on UPDATE

623209Feb 14 2008 — edited Feb 14 2008

Hi All,
MS SQL has a NOLOCK option that could be specified along with a SELECT / UPDATE to avoid locks on the tables. What equivalent option is available in Oracle ? If not what is the best method that can be used to keep row locks to a minimum ? I am not a developer but I am aware of the various UPDATE methods but would be grateful if any of your experience has let you choose a particular method. This is on Oracle 10g R1.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2008

Added on Feb 14 2008

5 comments

7,860 views