What are the Diff B/W Cursor and REF Cursor
Answers were Sorted based on User's Feedback
Answer / 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.
4. A ref cursor can not be used in CURSOR FOR LOOP, it must be used in simple CURSOR LOOP statement.
5. A ref cursor is defined at runtime and can be opened dynamically but a regular cursor is static and defined at compile time.
6. A ref cursor can be passed to another PL/SQL routine (function or procedure) or returned to a client. A regular cursor cannot be returned to a client application and must be consumed within same routine.
7) A ref cursor incurs a parsing penalty because it cannot cached but regular cursor will be cached by PL/SQL which can lead to a significant reduction in CPU utilization.
8) A regular cursor can be defined outside of a procedure or a function as a global package variable. A ref cursor cannot be; it must be local in scope to a block of PL/SQL code.
9) A regular cursor can more efficiently retrieve data than ref cursor. A regular cursor can implicitly fetch 100 rows at a time if used with CURSOR FOR LOOP. A ref cursor must use explicit array fetching.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
where are cookies actually stored on the hard disk? : Sql dba
what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 Answers Fiserv, Herbinger, Synechron,
What are sql built in functions?
How many types of relationship are there?
What does where 1 1 mean in sql?
after tell procedure whole code he asked can i write the same way in a function
how to get a list of columns in an existing table? : Sql dba
What are the different types of triggers?
What can sql server reporting services do?
how many ways to get the current time? : Sql dba
What is pl/sql table? Why is it used?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?