Answer Posted / anirban mitra

SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT MAX(SAL)
FROM EMP UNION SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN
(SELECT MAX(SAL) FROM EMP))

Can group functions be used in the order by clause in oracle?

997

---

What do you mean by merge in oracle and how can you merge two tables?

948

---

What is meant by a deadlock situation?

1109

---

What are the restrictions in a oracle read only transaction?

1034

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2307

---

How to create a new oracle data file?

1032

---

Which is faster join or subquery in oracle?

995

---

What to do if dba lost the system password?

1172

---

11. Display the client number and name and the client number and name of the person who referred that client.

2339

---

Can we store pictures in the database and if so, how it can be done?

1043

---

Explain oracle instance.

1175

---

What is a partition in oracle?

1122

---

How remove data files before opening a database?

1072

---

How is it different from a normal table?

1032

---