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 |
how can we return morethan one parameters in procedure?
What is sca and how is it useful?
How to print multi currency,multi language in xml?
tell me the scenarios of between pages in reports
for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake
What is set function in sql .E.g.What is difference between union and union all
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
is it possible to run the interface without using oracle apps?
What r the validation done in ap inbound ?
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
how to print multi lay outs,muti currency,muti language in xml publisher