what are different types of locks?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain database link?

745


What is a subquery in oracle?

664


Explain mutating triggers.

674


What is Data Dictionary Cache in Oracle?

757


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1036






Explain the dml?

666


How to view existing locks on the database?

642


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1805


What is sharded cluster?

611


How do I know if oracle is installed on windows?

553


What is the dynamic sql in oracle?

690


How translate command is different from replace?

633


how can we store any pdf file in oracle

1732


What is a dead lock in oracle?

688


What is redo log?

711