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 ;

Explain the difference between drop and truncate commands in sql?

1032

---

What is sql query limit?

969

---

How many sql statements are used?

1006

---

What is int identity in sql?

1123

---

Does pdo prevent sql injection?

924

---

What is the purpose of my sql?

943

---

What is sorting in sql?

935

---

Can we delete column in sql?

1085

---

What operators deal with null?

1097

---

What is the difference between inner join and outer join?

984

---

Which table is left in join?

969

---

How does one load ebcdic data? : aql loader

1159

---

What is difference between inner join and cross join?

961

---

What is sql catalog?

1010

---

Is left join inner or outer?

1010

---