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 is the difference between %_all and %_f tables

1 Answers  

---

What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

in which table sub inventory related information for item is stored?

3 Answers   chain sys, Scan Steel,

---

what is multi org structure?

3 Answers   Covansys, TCS,

---

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

0 Answers   Cap Gemini,

---

where we find the status of order information.

2 Answers  

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---