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

why r u move in the cus_top only why not move another top

4 Answers  

In sequence i want to 11 and 15th values how we will write?

0 Answers  

Do you know what are user profiles in apps. Any examples you can give?

0 Answers  

Hoe to skip middle of the record by using SQL*Loader?

5 Answers  

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,

Is SOB is attached with Business grp ?

2 Answers   Convergys,

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

what is difference between API and Interface?

2 Answers   Infogain,