Answer / mylapuram

USE SQL%ROWCOUNT to find whether any records are updated.

IF SQL%ROWCOUNT =0 then

-- no records are updated
else
-- records are update

Answer / hari

BY USING IMPLICIT CURSOR ATTRIBUTES

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

---

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,

---

in procedure how to return a value

2 Answers   Wipro,

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---

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

4 Answers   IBM,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

What are documents and test cases u followed.

2 Answers   Accenture,

---

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,

---

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 SET-OF-BOOKS?

3 Answers  

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---