what are different types of locks?
Answers were Sorted based on User's Feedback
Answer / bibhuti bhusan patra
implicit locks & explicit locks
implicit locks are maintained by oracle internally.
&explicit locks are performed by user manualy.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shanmugavelu
row level and table level locks,
dont try share update lock its failure in table lelvel ..
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pratap dixit
Pessimistic and Optimistic lock
Pessimistic- at the time of reading , locking the row
Optimistic- at time of updating , locking the row.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / a.brahmam
mainly two types of locks
1.Row Level Locks
2.Table Level Locks
Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock
Is This Answer Correct ? | 0 Yes | 0 No |
How to define a procedure inside another procedure?
How to add a new column to an existing table with a default value?
How do I spool to a csv formatted file using sqlplus?
hai, when to use char and varchar2....?
how do u setup a replication site?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is archive log in Oracle?
How to convert characters to times in oracle?
what are the diffeenes between oracle 9i,oracle 10g
What is the difference between $oracle_base and $oracle_home?
How index is implemented in oracle database?