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.

How can you achieve loose coupling in soa framework?

1226

---

what is pay run id ?

2196

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1123

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2048

---

what is global tempory table?

7210

---

What is oracle soa suite?

1235

---

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

2663

---

q)what are the validations in sql*loader

2405

---

What is the concept of soa governance?

1254

---

List the various types of value set.

1082

---

can we get profile values in report without using user exists is it possible how?

2884

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2616

---

How many schemas we have? how many you have used?

2069

---

What is a flexfield? List out its types.

1170

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2107

---