Types of cursor locks and explanation each of them ?

Answers were Sorted based on User's Feedback



Types of cursor locks and explanation each of them ?..

Answer / mehul patel

acLockPesimistic - locks the row when it read it and hold
the lock still updates it.
adLockOptimistic - locks the row whenit updates it.
adLockOptimistic - locks the row at the time it updates it.
adlockforwardonly - readonly.

Is This Answer Correct ?    5 Yes 2 No

Types of cursor locks and explanation each of them ?..

Answer / rtr

a

Is This Answer Correct ?    4 Yes 2 No

Types of cursor locks and explanation each of them ?..

Answer / kalyan dhara

FOR UPDATE and CURRENT OF
---------------
When you issue a SELECT...FOR UPDATE statement, the RDBMS
automatically obtains exclusive row-level locks on all the
rows identified by the SELECT statement, holding the records
“for your changes only” as you move through the rows
retrieved by the cursor. No one else will be able to change
any of these records until you perform a ROLLBACK or a COMMIT.

CURSOR toys_cur IS
SELECT name, manufacturer, preference_level,
sell_at_yardsale_flag
FROM my_sons_collection
WHERE hours_used = 0
FOR UPDATE;

UPDATE table_name
SET set_clause
WHERE CURRENT OF toys_cur ;

OR

DELETE FROM table_name
WHERE CURRENT OF toys_cur ;

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How does a covering index work?

0 Answers  


how to include numeric values in sql statements? : Sql dba

0 Answers  


What are stored procedures in mysql?

0 Answers  


What is record variable?

0 Answers  


What are Global Temporary tables

3 Answers   IBM, TCS,






How would you convert date into julian date format?

0 Answers  


what are the advantages of package?

7 Answers   iFlex,


Which is better stored procedure or query?

0 Answers  


if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,


Explain dml and ddl?

0 Answers  


What is exception? What are the types of exceptions?

0 Answers  


What is the difference between sum and count in sql?

0 Answers  


Categories