Last post Aug 24, 2012 02:12 AM by Ajay2707
Aug 18, 2012 11:30 PM|aoshi_kh|LINK
Aug 19, 2012 05:23 PM|Lannie|LINK
No locks on SELECT data.
Row lock on INSERT, UPDATE, DELETE in progress.
Aug 24, 2012 02:12 AM|Ajay2707|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.