Answer / mehul patel

acLockPesimistic - locks the row when it read it and hold
the lock still updates it.
adLockOptimistic - locks the row whenit updates it.
adLockOptimistic - locks the row at the time it updates it.
adlockforwardonly - readonly.

Answer / rtr

a

Answer / 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 stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

Is oracel sql developer written in java?

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

How does pl sql work?

0 Answers  

---

What does sql stand for?

0 Answers  

---

What is view explain with example?

0 Answers  

---

What is a behavioral trigger?

0 Answers  

---

What is Highwatermark?

3 Answers   Thermotech,

---

Which tcp/ip port does sql server run?

0 Answers  

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

---