Explain the usage of WHERE CURRENT OF clause in cursors ?
- 4 Answers
- 13252 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 cross join is used?
How to use distinct and count in sql query? Explain
Explain select statements in sql?
What is difference between hql and sql?
What are analytic functions in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What are different types of sql commands?
Explain exception handling in pl/sql?
When you have to use a default "rollback to" savepoint of plvlog?
What are its different types of dbms?
What is error ora-01000: maximum open cursors exceeded
What is sql keyword?
How do you remove duplicate records from a table?
how to add a new column to an existing table in mysql? : Sql dba
what are all types of user defined functions? : Sql dba
