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 is the concept of soa governance?

1249

---

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

2881

---

What do you understand by a set of books?

1114

---

Can u give the Documentation of Custom.pll in oracle apps

3475

---

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

1081

---

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

1063

---

What are the Standard Reports and Forms in HRMS?

2314

---

What is a flexfield? List out its types.

1166

---

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

2261

---

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

2660

---

what are the prerequisites for costing transactions?

3136

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2632

---

What is a value set? List its various types.

1096

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2382

---

What is sca and how is it useful?

1125

---