Types of cursor locks and explanation each of them ?
Answer Posted / 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 |
Post New Answer View All Answers
What is mutating error in pl sql?
Explain what is table in a database?
Does sql profiler affect performance?
How to place comments in pl/sql?
What are the operators in sql?
How much does sql certification cost?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is the usage of sql functions?
Which is faster view or stored procedure?
what is top in tsql? : Transact sql
how to return query output in html format? : Sql dba
What is interval partition?
Can we perform dml on view?
What is sql analyzer?
Explain spool.