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 are the basic techniques of indexing?
how mysql optimizes distinct? : Sql dba
What are the possible values for the boolean data field?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is left inner join in sql?
how do you know the version of your mysql server? : Sql dba
what is the difference between where clause and having clause? : Sql dba
What is an invalid partition table?
What is rownum in sql?
What are the different types of dbmss?
how would you get the current date in mysql? : Sql dba
Does access use sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Can we write dml inside a function in sql server?
