Answer / saleem

It is dynamic Cursor.
They are two types

1) Strong- Return type
2) weak- No Return type

Answer / sankar

CURSOR IN WHICH QUERY CAN BE CHANGED AT RUNTIME IS CALLED
REF CURSOR.

Answer / kapil gangrade

ref cusor is a dynamic type of cursor which is used to
provide Reusability of cursor.......

Answer / shukla

Ref Cursor is a PL/SQL Datatype. This is used to store
result of a query. Ref cursor is used in situations when
you want to encapsulate logic within sub-program i.e. your
query is changing depending on certain criterian. This
reduces the complexity of our program if we were to
implement same logic in a single query for getting the
desired output.

Answer / venu

Reusability of cursor

Answer / shaveta gulati

Ref Cursor:

ref cursor is a data structure which points to an object
which in turn points to the memory location.

ex:

create or replace procedure test()

as

begin

type ref_cursor is ref cursor;

open ref_cursor as

select * from table_name;

end;

There are 2 types in this.

1.strong ref cursor:

This has a return type defined.

2. weak ref cursor.

this doesnt have a return type

normal cursor:

Nothing but the named memory location.

it has 2 types

1. explicit cursor

Need to be defined whenever required.

2.Implicit cursor

need not defined and used by oracle implicitly in DML
operation.

In case of an normal explict cursor, the SQL query has to
be defined at the time of declaring the cursor itself. In
case of REF Cursor, the cursor declartion is not associated
with any SQL query, it is associated with a query at a
later stage this brings in a lot of flexibility as
different SQL queries can be associated with the cursor
(one at a time, offcourse) programatically. REF Cursors
also provide the feature of passing parameters. Though
there is something dynamic with REF Cursor when compared to
a normal explicit cursor, it is not a truly perfect dynamic
cursor. Truly perfect dynamic cursors are the one
constructed using DBMS_SQL package.

Answer / a.v.bhaskar reddy

REF CURSOR is majorly used when we want to execute a
dynamic select statement causes to retrieve more than one
record. We can pass Ref cursor result as a out parameter
which can be used in other subprograms

Answer / manish sharma

a refrence cursor is data type like record type etc,we can
call it dynamiclly ,its an cursor so that it is binding of
more querry.so that if we need more querry output at run
time we can use it,in a normal cursour must have a
declarative part but in a ref cursor,we can call the cursor
without declration of cursor.

Answer / a.v.bhaskar reddy

Ref cursor are the pointor to the server side cursor
variables they can be attached to diff statments and can
store diff value during runtime.i mean they act basically
dynamiclly we call them as true PLSQL variable

Answer / niranjan kumar

Ref Cursor is also known as dynamic cursor,it is a data
type to solve situation which demand run time where
condition.Without creating instance we cannot use refcursor.

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,

Stored procedure?

4 Answers  

what are the receipt types in Po?

2 Answers   Evosys, UST,

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

what is the difference between procedure and function

3 Answers   Wipro,