Answer Posted / samad

delete from emp a where rowid >(select min(rowid) from emp
b where a.rowid = b.rowid);
2. DELETE FROM EMP A
WHERE ROWID > ( SELECT min(ROWID) FROM EMP B WHERE
A.ROWID = B.ROWID)

cheers
samad

Explain what are the tables of auto invoice?

1102

---

In sequence i want to 11 and 15th values how we will write?

2044

---

tell me the scenarios of the independent in reports

2456

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3000

---

List the various types of value set.

1035

---

what are the prerequisites for costing transactions?

3105

---

List the types of flexfield?

1003

---

How to move the one file from one instance to another instance? And your scripts also?

1078

---

What is the concept of soa governance?

1231

---

Can you explain the difference between architecture followed in 10g & 11g?

1031

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2059

---

How do you register report in oracle apps?

1046

---

Tell me where we find the status of order information?

1114

---

In hierarchical structure of a database? we have write query from where we should start?

2197

---

tell my any difficult situtation you solved in your experience in your company?

2292

---