Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: row level locking

    How to realize row level locking when updating table .?
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Mar 2003
    Location
    N Delhi
    Posts
    11
    You can confirm it from SQL Query analyzer by executing procedure sp_lock. Execute sp_lock whenever you want to check locks after a particular query to some database.

  3. #3
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    sp_indexoption

Posting Permissions

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