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

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

1288

---

What does appl_top directory contain?

1121

---

How to create a purchase order without a requisition?

1197

---

Tell me how to find the custom directory in front end?

1111

---

What are do's and dont's of Interface?

2430

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3065

---

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

2421

---

What is count(*) from po_vendors(any table)?

1089

---

What are file in oracle.

2238

---

What is a value set? List its various types.

1099

---

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

1123

---

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

2107

---

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

2129

---

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

---

Is soa a part of oracle fusion middleware?

1090

---