Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 4 Answers
- 14047 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 do we use partitions in sql?
Which sql most popular?
Why use triggers in sql?
what is difference between delete and truncate commands? : Sql dba
Does asenumerable execute the query?
Are sql database names case sensitive?
What does := mean in pl sql?
Write a query to find the names of users that begin with "um" in sql?
How do you drop a trigger?
What is meant by user defined function?
What is bulk collect in pl sql?
discuss about myisam key cache. : Sql dba
What is write ahead logging in sql server?
What is set serveroutput on in pl sql?
Write an sql query to select all records from the table?
