Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 24, 2012 06:12 AM by Ajay2707
Aug 19, 2012 03:30 AM|LINK
Aug 19, 2012 09:23 PM|LINK
No locks on SELECT data.
Row lock on INSERT, UPDATE, DELETE in progress.
Aug 24, 2012 06:12 AM|LINK
As lannie said, by default No lock in select data. you don't need nolock with Oracle.
FROM master WITH (NOLOCK)
But when update cluase with select statement it create lock temporary.
normal select -- no lock
insert , update , delete , select for update -- lock
see more for how to lock work.