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

What are the types of keys?

991

---

what does it mean to have quoted_identifier on? : Sql dba

1144

---

Why query optimization is needed?

921

---

Explain what is sql*plus?

1138

---

What is sql and also describe types of sql statements?

1059

---

Does sql between include endpoints?

1001

---

How can we make an if statement within a select statement?

1008

---

Advantages and disadvantages of stored procedure?

1120

---

What are predefined functions in sql?

1042

---

Why is partition used in sql?

1122

---

What is trigger and how to use it in sql?

1021

---

how to enter characters as hex numbers? : Sql dba

1038

---

What is column?

985

---

what tools available for managing mysql server? : Sql dba

1078

---

How do I upgrade sql?

998

---