Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 4 Answers
- 14083 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / rahul koshti
By using WHERE CURRENT OF clause you can update or delete
records from the table where CURSOR fetched the records. But
for this you MUST have to open cursor with the clause of
'FOR UPDATE [OF COLUMN_NAME]'.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How do you clear the screen in sql?
Explain the savepoint statement.
What do you understand by pl/sql cursors?
What is the difference between an inner join and an outer join?
What is sql and how does it work?
Why stored procedure is faster than query?
How much does sql cost?
What are the disadvantages of not performing database normalization?
What is the usage of when clause in trigger?
How can I speed up sql query?
What are different types of sql?
What is the use of sql trace?
What is the use of triggers?
Is primary key always clustered index?
Explain scalar functions in sql?
