how a reference cursor works?what all adnvantages are gained with it..specify

how a reference cursor works?what all adnvantages are
gained with it..specify the situation?

Question Posted / sudhir

4 Answers
12934 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how a reference cursor works?what all adnvantages are gained with it..specify the situation?..

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;

Is This Answer Correct ?

6 Yes

1 No

how a reference cursor works?what all adnvantages are gained with it..specify the situation?..

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.

Is This Answer Correct ?

2 Yes

0 No

how a reference cursor works?what all adnvantages are gained with it..specify the situation?..

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

Is This Answer Correct ?

2 Yes

1 No

how a reference cursor works?what all adnvantages are gained with it..specify the situation?..

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.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer