how a reference cursor works?what all adnvantages are
gained with it..specify the situation?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What are the constraints available in sql?
Is left join and outer join same?
In a table only one column how to update rows
What are the two types of periodical indexes?
What is a recursive join sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
what is switch column,colums cost in oracle?
What is clause in sql?
What are hotfixes and patches?
How to combine two stored procedures in sql?
What is the difference between UNIQUE KEY and UNIQUE INDEX?
How can you get sql*loader to commit only at the end of the load file? : aql loader