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.

What r the validation types?

3 Answers  

---

what is the difference between procedure and function

4 Answers  

---

what are the types of interfacing?

3 Answers   TCS,

---

What is oracle soa suite?

0 Answers  

---

Which oracle apps version you are very confident in?

0 Answers  

---

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

in procedure how to return a value

2 Answers   Wipro,

---

Is it possible to do purchase order without requisition?

8 Answers  

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---