What is REF Cursor?
Answers were Sorted based on User's Feedback
Answer / dyna
Ref cursor is a kind of cursor that allows dynamic data
manipulation
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / vivekananda
It is used to return a recordset from a stored procedure.
There are two types of REF-CURSORS.
One is STRONG REF-CUSROR.
Another is WEAK REF-CUURSOR.
For the STRONG REF-CUSROR, the returning columns with
datatype and length need to be known at compile time.
For the WEAK REF-CUURSOR, no need to be known at compile
time.
Eg:
type STRONG_REF_CURSOR is REF CURSOR return EMP%ROWTYPE;
type WEAK_REF_CURSOR is REF CURSOR;
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / suresh
Ref cursor is a dynamic cursor. it will open more then one active set area.we two types of ref cursors.
1.strong ref cursor-with return type.
2.weak ref cursor- with out return type.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sirisha
Reference cursors donot have a select statement when it is
declared. It is associated with the select statement at a
later stage. These are used when we want to process large
queries
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / dinesh
ref is a cursor.it is used to database and data structure
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swati
jo cursor har baar, baar baar aur lagatar use hota hai use
ref cursor kahte hai...........
so simple it is.........
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / cyril mathew
A REF CURSOR is basically a data type. A variable created
based on such a data type is generally called a cursor
variable. A cursor variable can be associated with
different queries at run-time.
type r_cursor is REF CURSOR;
c_emp r_cursor;
en emp.ename%type;
begin
open c_emp for select ename from emp;
loop
fetch c_emp into en;
exit when c_emp%notfound;
dbms_output.put_line(en);
end loop;
close c_emp;
end;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raina
here you r with ur answer refcursor is a pointer which
points to the o/p of ur cursor the moment u close ur cursor
it becomes invalid .the diff b/w ref cursor n cursor is that
u can asssingn multiple quries to ur ref cursor but with ur
normal cursor ur query is static
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vidyasagar
Ref Cursor is a cursor which is used to process bulk no. of
statements. And it uses the anonymous table space in the
database
Is This Answer Correct ? | 38 Yes | 42 No |
wht is format triger?
what is meant by Table space?
how to create a file in forms?
what is Flex mode and Confine mode?
What is procedure?
What is responsibility and how u attach
tell my any difficult situtation you solved in your experience in your company?
what are the balancing segments in AR?
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference
In report we have to show two Layout? how it is and how we can see from where it?
In unix Schell sript what is very 1st line to be wriiten .
what is flexfield qualifier?