Answer / swapnareddy

Basically, Reference cursor is datatype.Reference cursor works
as a cursor variable.the advantage of using reference cursor
is it pass the result sets to the subprograms
(ie,procedures,packages and functions etc).
example for reference cursor usage:
type r_cursor is ref cursor;
c_emp r_cursor;
ename1 emp.ename%type;
begin
open c_emp is select ename from emp;
loop
fetch c_emp into ename1;
exit when c_emp% notfound;
dbms_output.put_line(ename1);
end loop;
close c_emp;
end;

Answer / narendrareddy

Generally, through static cursors we are using only one select statement at a time for single active set area. Whereas, in ref cursor we are executing number of select statements dynamically for single active set area. That’s why these types of cursors are called dynamic cursors.

1) Strong Ref Cursor: Having return type.
2) Weak Ref Cursor: Does not have return type.

Answer / rahul

1) It's a datatype.
2) variable created based on this is called cursor variable
3) advantage is their capability to pass result sets between
programs

Answer / a.jyothsna

Difference between cursor and ref-cursors is same as the
difference between variable and constant.
With ref-cursors we can use the cursors variable.

What are the data types allowed in a table?

3 Answers  

---

What is the purpose of primary key?

0 Answers  

---

How do I create an index in word?

0 Answers  

---

What is the trigger in sql?

0 Answers  

---

Can we use ddl commands in pl sql?

0 Answers  

---

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

How do I count rows in sql?

0 Answers  

---

Explain how to use transactions efficiently : transact sql

0 Answers  

---

How do you delete duplicates in sql query using rowid?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---

How many sql statements are used?

0 Answers  

---