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 where we find the status of order information?

1135

---

testing tools?

2250

---

what is the differences between internal requisition and internal sales order?

2657

---

What do you understand by soa and what are the benefits of using this architecture?

1081

---

What is the concept of soa governance?

1249

---

q)what are the validations in sql*loader

2400

---

where to define interorganization transaction charges and what are the different options?

2417

---

what is the difference between request group and request security in oracle apps?

5894

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2632

---

Which oracle apps version you are very confident in?

1205

---

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

2076

---

Can you explain the difference between architecture followed in 10g & 11g?

1065

---

Are you familiar with internet architecture of oracle apps 11i?

1063

---

please send me forms, xml pulisher questions,answers

2108

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2219

---