Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the usage of WHERE CURRENT OF clause in cursors ?
- 4 Answers
- 14304 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 to do backup entire database? : Transact sql
Mention what plvcmt and plvrb does in pl/sql?
how many ways we can we find the current date using mysql? : Sql dba
What is a composite primary key?
What are the sql versions?
What is sql and explain its components?
how to shut down the server with 'mysqladmin'? : Sql dba
What are the differences between implicit and explicit cursors?
what is msql? : Sql dba
What will you get by the cursor attribute sql%found?
what are all the different normalizations? : Sql dba
Where the sql database files are stored?
What is the best partition size for windows 10?
What is union and union all keyword in sql and what are their differences?
What is pl sql block in dbms?
