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 are the steps for performance tuning.
What is the clause we need to add in function body to return variable?
What is the difference between python and sql?
What is int identity in sql?
What is the use of index in sql?
What is set transaction?
What do you mean by “trigger” in sql?
Does truncate require commit?
what happens if you no create privilege in a database? : Sql dba
What are functions in sql?
How do I install microsoft sql?
Which is faster count (*) or count 1?
Why is a trigger used?
What is a Mapplet?
Can unique keys be null?