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;

What are file in oracle.

2285

---

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

2709

---

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

1128

---

What is sca and how is it useful?

1171

---

Can you differentiate between mediator and osb?

1193

---

how can i print random rows in plsql table

2571

---

What do you understand by concurrent programs?

1145

---

Tell me how to debug the report?

1171

---

What is the concept of soa governance?

1318

---

what are the prerequisites for costing transactions?

3186

---

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

2264

---

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

2312

---

Can we create tables in apps schema?

1184

---

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

2933

---

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

1143

---