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
Explain cursor types?
What does varchar include?
what is sub-query? : Transact sql
what is the difference between delete and truncate commands? : Sql dba
What is the purpose of the primary key?
Name the operator which is used in the query for pattern matching?
what is primary key? : Sql dba
Does sql view stored data?
How do you break a loop in pl sql?
how to calculate expressions with sql statements? : Sql dba
Explain what is a column in a table?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
what is cursor. write example of it. What are the attributes of cursor.
Can a foreign key be null?
Who is the owner of mysql database?