Answer Posted / anil
1.REF CURSOR is basically a data type. It is normally declared as type r_cursor is REF CURSOR.
CURSOR is not a datatype.
2.REF CURSOR is dynamic , CURSOR is static
3.REF CURSOR can be passed from one procedure to other procedure but CURSOR cant be passed from one procedure to other.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List the ways to get the count of records in a table?
How to find 3rd highest salary of an employee from the employee table in sql?
How do you write a complex sql query?
what are the limitations of identity column? : Transact sql
How many types of privileges are available in sql?
Is sql better than excel?
What is primary and foreign key?
Where is sql database stored?
How can you know that statistics should be updated?
what is a trigger in mysql? Define different types of trigger. : Sql dba
Whis is not false in primary key?
When is the explicit cursor used ?
List different type of expressions with the example.
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Are stored procedures compiled?
