Explain the usage of WHERE CURRENT OF clause in cursors ?
Answer Posted / nishi
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why plvtab is considered as the easiest way to access the pl/sql table?
What is break?
What is scope and visibility in PL/SQL?
Explain alias in sql?
How can we find duplicate records in a table?
What is error ora-12154: tns:could not resolve the connect identifier specified?
How to rename a column in the output of sql query?
How is sql used in oracle?
What is the difference between having and a where in sql?
How will you distinguish a global variable with a local variable in pl/sql?
What is a system versioned table?
What is rtm in testing?
What are the types of views in sql?
What are the two parts of design view?
When to use inner join and left join?