Answer Posted / ankit kumar srivastava

DELETE FROM EMP_a WHERE ROWID NOT IN(
(SELECT MAX(ROWID) FROM EMP_a a GROUP BY
EMPNO,ENAME,sex,doj,sal,deptno,mgr HAVING COUNT(ROWID)
=1)
UNION
(SELECT MAX(ROWID) FROM EMP_a a GROUP BY
EMPNO,ENAME,sex,doj,sal,deptno,mgr HAVING COUNT(ROWID)>1))

What are file in oracle.

2204

---

How can a process be deployed in soa?

1191

---

Do you know what are user profiles in apps. Any examples you can give?

1066

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2231

---

what is global tempory table?

7167

---

q)what are the validations in sql*loader

2365

---

What is instead of trigger in where we will use?

1147

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2191

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1087

---

What are the Standard Reports and Forms in HRMS?

2266

---

Explain what are the tables of auto invoice?

1112

---

what is the difference between request group and request security in oracle apps?

5836

---

How can we import the data into a database using sql * loader?

1145

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2100

---

What are the different components of soa suite?

1177

---