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 is the use of function "module procedure" in pl/sql?

1146

---

What is the difference between function and procedure in pl/sql?

1028

---

what is a database? : Sql dba

1112

---

What are expressions?

965

---

Explain commit, rollback and savepoint.

947

---

how to return query output in html format? : Sql dba

1034

---

Is sql a microsoft product?

905

---

What are the different types of sql commands?

1073

---

Explain the difference between rename and alias?

976

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1106

---

What are tuples in sql?

1078

---

Where not exists in sql?

930

---

What is %type in sql?

927

---

What is oracle sql developer?

1002

---

What is basic structure of pl sql?

1005

---