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 ;

Can we use insert statement in function?

940

---

How do you break a loop in pl sql?

985

---

What are all the different types of indexes?

1091

---

What is a schema? How is it useful in sql servers?

1042

---

explain access control lists. : Sql dba

947

---

Does sql full backup truncate logs?

965

---

What is string join?

932

---

what are the advantages of mysql in comparison to oracle? : Sql dba

939

---

How do I view tables in mysql?

915

---

What is set serveroutput on?

1087

---

What is data type in database?

931

---

Explain the savepoint statement.

1038

---

Is it possible for a table to have more than one foreign key?

976

---

Write a sql select query that only returns each name only once from a table?

959

---

Can unique keys be null?

850

---