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;

please send me forms, xml pulisher questions,answers

2069

---

What are the different components of soa suite?

1148

---

Do you know what is applysys in oracle application database schema, what is apps?

1138

---

how to print multi lay outs,muti currency,muti language in xml publisher

12154

---

How is choreography different from orchestration?

1088

---

Explain oracle apps architecture.

1194

---

what are the balancing segments in AR?

2042

---

What is oracle soa suite and what are its different components?

1137

---

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

2164

---

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

2073

---

What does appl_top directory contain?

1080

---

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

1029

---

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

2025

---

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

5797

---

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

1036

---