Answer Posted / swapna
A Reference Cursor is majorly used when we want to execute
a dynamic select statement causes to retrieve more than
one record. We can pass Reference cursor result as a out
parameter which can be used in other sub programs.
| Is This Answer Correct ? | 27 Yes | 7 No |
Post New Answer View All Answers
What is group function in sql?
What is the difference between left and left outer join?
How do you create an update query?
What is cursor explain with example?
What are the types of queries in sql?
What are %type and %rowtype for?
What is the use of partition by in sql?
How do you change a value in sql?
What is sqlerrd?
Is sql injection illegal?
What is error ora-01000: maximum open cursors exceeded
Why we use triggers in mysql?
How to check if a column is nullable before setting to nullable?
What is cte?
What is file based approach?
