var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: NOLOCK equivalent ?
In SQL Server , NOLOCK is used to do READUNCOMMITTED in select stts.
Select *from table1(NOLOCK) // If any update happens during 'select' executed by one user, even the uncommitted data will be read ( dirty read )
Can any tell, what is the equivalent of this in Oracle ? Oracle has update_lock_type=NOLOCK, but I need the same in Select stt. Any idea ?
There are no dirty reads in Oracle - it just can't be done (which is good!)
I have never heard of this update_lock_type=NOLOCK concept either - and it isn't documented.