Answer / dyna

Ref cursor is a kind of cursor that allows dynamic data
manipulation

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;

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.

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

Answer / dinesh

ref is a cursor.it is used to database and data structure

Answer / swati

jo cursor har baar, baar baar aur lagatar use hota hai use
ref cursor kahte hai...........
so simple it is.........

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;

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

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

name all status attributes.

1 Answers   Scan Steel,

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

What is sca and how is it useful?

0 Answers  

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,

What is procedure?

3 Answers   IBM,

What are profile options?

4 Answers   Accenture,

in reports token is casesensitive or not?

2 Answers  

Can u give the Documentation of Custom.pll in oracle apps

0 Answers  

what is mean by confine mode and flexi mode?

2 Answers  

FLEX FIELDS?

2 Answers