Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: NOLOCK equivalent ?

    Hi all,

    In SQL Server , NOLOCK is used to do READUNCOMMITTED in select stts.

    Eg :

    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 ?

    Thanks,
    sam

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •