Answer / guest

EVERY SQL STMT IMPLICITY OPENS ONE CURSOR AND PARSE AND
EXECUTE QUERY FOR EVER STMT IT WILL FIRE
IMPLIST
SQL%

Answer / venkatesh

oracle automatically creates area for DML operations
programmer ill not have control for this cursor.
%found,%notfound,%rowcount,%isopen

Explicit cursor is user has to declare and open and
fetch for DML sql statment into this cursor explicit cursor
attributes are
sql%found,sql%notfound,sql%rowcount,sql%isopen

refcursor is datatype,a variable created based on such a
datatype is generally called cursor variable associated
with different queries at run-time.,by using this variable
capability to pass result sets between subprograms.

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---

what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

---

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

---

Explain oracle apps architecture.

0 Answers  

---

---

What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,

---

in reports token is casesensitive or not?

2 Answers  

---

explain registration steps of a concurrent program.

1 Answers   TCS,

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

Can u attach Request set with in the Request set?

2 Answers   Satyam,

---

What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---