Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 4 Answers
- 14478 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 take the union of two tables in sql?
What are the different types of constraints?
How do you drop a trigger?
What is the order of sql select?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is sql data?
How do I find duplicates in sql?
Is nosql faster than sql?
Is sql open source?
What is a sql instance vs database?
What is the maximum number of rows in sql table?
What is a data definition language?
What is a left join?
How do I count duplicates in sql?
what is error ora-03113: end-of-file on communication channel?
