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.

Answer / rtr

a

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 ;

How do you retrieve the last N records from a table?

10 Answers  

---

What are all types of user defined functions?

0 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

What are the two characteristics of a primary key?

0 Answers  

---

What is record in pl sql?

0 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---

How do I remove all records from a table?

0 Answers  

---

What is sqlerrm?

0 Answers  

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What do you understand by pl/sql records?

0 Answers  

---

What is form and report?

0 Answers  

---