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 ;

How do I clear the screen in sql plus?

1041

---

What is difference between hql and native sql?

1175

---

What is the difference between a subquery and a join?

1108

---

how to fetch alternate records from a table? : Sql dba

1112

---

What is the difference between subquery and correlated query?

1065

---

What is left join in sql?

1051

---

How many clustered indexes can you have?

975

---

What are views in sql?

988

---

What are tables and fields?

1033

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2023

---

How do I view stored procedures?

975

---

What is a string data type in sql?

1045

---

how many ways to get the current time? : Sql dba

1007

---

What does 0 mean in sql?

965

---

what is sql? : Sql dba

1030

---