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.
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.

What is the difference between null value, zero, and blank space?

1206

---

How is data stored on a disk?

1036

---

Does oracle roll back the transaction on an error?

1013

---

What is the use of nvl function?

1198

---

what is the bond code in materialized view?

3002

---

Can you skip header records while loading? : aql loader

1053

---

What is index example?

1010

---

What are the different ways to optimize a sql query?

946

---

What is a constraint?

1023

---

what is the difference between char_length and length? : Sql dba

1045

---

Can we create foreign key without primary key?

985

---

What is the main difference between sql and pl/sql?

1096

---

when is the use of update_statistics command? : Sql dba

1049

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1014

---

What are the features of pl sql?

1067

---