Explain the usage of WHERE CURRENT OF clause in cursors ?
Answer Posted / swapna
WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Explain what is a database?
What is difference between primary and secondary key?
What is sql and explain its components?
Define commit, rollback and savepoint?
Do we need to rebuild index after truncate?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is denormalization in a database?
what is bcp? When is it used?
Which normal form is best?
Does sql full backup truncate logs?
What is gpt format?
Why do we use %rowtype & %type in plsql?
Are subqueries better than joins?
Can a key be both primary and foreign?