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

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

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 difference between po_headers_all and po_headers

5 Answers   Deloitte, Wipro,

What are the Major differences bteween key flexfields ,descriptive flexfields

4 Answers   Sierra Atlantica, TechBulls,

i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,

how to move the one file from one instance to another instance?and ur scripts also?

1 Answers   KPMG,

In interface how u find errors and how to solve. How to fix it?

3 Answers  

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

can we write sql statement in Format trigger?

4 Answers