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
What is difference between joins and union?
What are triggers and its uses?
how many ways to get the current time? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
Can we create table inside stored procedure?
Does sap use sql?
Is keyword pl sql?
What has stored procedures in sql and how we can use it?
What is a natural join sql?
Does pdo prevent sql injection?
how would you enter characters as hex numbers? : Sql dba
What are pl/sql packages?
Is sql microsoft?
What is sql resultset?
Can we use delete in merge statement?