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

Tell me some interface tables on ordermangement.

1 Answers   Zensar,

What is sca and how is it useful?

0 Answers  

How to retry multiple errored workflow processes? What is the access level in workflow used for? How do you define start and end functions in workflow? How does they differ from normal functions? Give me some workflow tables? What is the difference between a function and notification in workflow? I have sent two different notifications to two different users and I want to wait till both they are approved to send 3rd notification. How can you achieve it? What is item type and item key in workflow? How do you use attribute values in workflow messages? How do you use lookups in workflow? What are roles in workflow and how they are used? How do you download or upload a workflow from a server? What are steps to customize the workflow? What functions can you perform from workflow administrator responsibility? To send an email to the user workflow notification is the only way or is there any other ways to send it? Give me some workflow standard procedures? How can you run/start/kickoff workflow? What is wf_engine package used for? How many processes can each workflow contain? What is Runnable option in workflow? At what level it exists? What are different types of attributes in workflow? How do you reassign a notification? What is process in workflow? How can you send direct oracle form link through workflow notifications? How can you send a notification to multiple users? Can you change the list dynamically? Can you send html code in workflow notification? I have sent two different notifications to two different users and I want to wait till atleast one is approved to send 3rd notification. How can you achieve it?

0 Answers   Accenture, CTS,

in one report using two layout models.if yes how to do

3 Answers   Wipro,

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

PL/SQL stored procedure parameters?

7 Answers  

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,

how can u link a org-id with a responsibility in reports?

2 Answers   TCS,

Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  

What are file in oracle.

0 Answers   BirlaSoft, IBM,

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers