Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is the primary key an index?
Can we edit a view in sql?
What does cursor do in sql?
What is rowid in sql?
What is sql performance tuning?
How do I pipe the output of one isql to another?
What does rownum mean in sql?
What is trigger and how to use it in sql?
What is lexical units in pl sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is an oracle stored procedure?
What are the dml statements?
How much does a sql dba make? : SQL DBA
Why self join is used in sql?
What is information schema in sql?
