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
Does pl sql work in mysql?
what is view? : Sql dba
what are the different tables present in mysql? : Sql dba
what are the different type of normalization? : Sql dba
What are the types of queries in sql?
What are different types of keys?
Is full outer join same as cross join?
How many types of triggers are there in pl sql?
Why is partition used in sql?
What does where 1/2 mean in sql?
Can we call stored procedure in function?
How to avoid using cursors?
Why do we use sql constraints?
how to get a list of indexes of an existing table? : Sql dba
How do I send sql query results to excel?
