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 recursive stored procedure?
Can sql developer connect to db2?
how to fetch common records from two tables? : Sql dba
How do I save a stored procedure?
What is execution plan in sql?
Is sqlite good enough for production?
Can we commit in trigger?
Can we create a trigger on view?
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the advantages of indexing?
how to include character strings in sql statements? : Sql dba
What is the difference between a primary key and a unique key?
Does pl/sql support create command?
what are all the different types of indexes? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba