how a reference cursor works?what all adnvantages are
gained with it..specify the situation?
Answer Posted / rahul
1) It's a datatype.
2) variable created based on this is called cursor variable
3) advantage is their capability to pass result sets between
programs
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how can we submit a form without a submit button? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is fmtonly in sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
What are conditional predicates?
Is sql pronounced sequel or sql?
What is triggering circuit?
Explain the working of foreign key?
Explain the significance of the & and && operators in pl sql.
What does subquery mean in sql?
What is the use of stored procedures?
What is Histogram?
What does 0 mean in sql?