Answer Posted / 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.

tell me the scenarios of the independent in reports

2564

---

Do you know where we can check the status of po?

1187

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2070

---

Explain what are the tables of auto invoice?

1093

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2208

---

please send me forms, xml pulisher questions,answers

2066

---

Is soa a part of oracle fusion middleware?

1034

---

Plz anybody send me Technical specification for AP Interface

2503

---

tell me the scenarios of the independent in reports

2433

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2167

---

What is sca and how is it useful?

1046

---

Explain oracle apps architecture.

1191

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2331

---

What are the different components of soa suite?

1144

---

How to move the one file from one instance to another instance? And your scripts also?

1063

---