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

What is the package?

2 Answers  

when will formula,place holder and summary columns fire in reports?

1 Answers   TCS,

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

what is repeting frame?

3 Answers   TCS,

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

whats the use of after parameter form and before report?

2 Answers   IBM,

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

What is the difference between base table and multi-org table?

3 Answers   Infosys,

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

name all status attributes.

1 Answers   Scan Steel,

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

How is choreography different from orchestration?

0 Answers