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.

How You Will display the key flexifields in your report

3 Answers   TCS,

---

How do u identity its name of report?

3 Answers  

---

How can a process be deployed in soa?

0 Answers  

---

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

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

4 Answers   Bosch, Collabera, Synechron,

---

where the accounting related data is stored ?

2 Answers  

---

hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---

where is setup of business group done?

2 Answers   TCS,

---

WHAT IS REFCURSOR IN ORACLE ?

6 Answers  

---

what are the types of interfacing?

3 Answers   TCS,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---