Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 4 Answers
- 14272 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
Why function is used in sql?
what is a cursor? : Sql dba
Can you upgrade sql express to full sql?
What is structural independence and why is it important?
What is the difference between instead of trigger and after trigger?
What are different methods to trace the pl/sql code?
What are the different types of a subquery?
What's the difference between a primary key and a clustered index?
What are synonyms in sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is sql partition?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is a design view?
what is a database lock ? : Sql dba
What is difference between procedure and trigger?
