Answer Posted / shrikant

SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal
DESC)

select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);

Select * from EMP_USER A where n-1 = (select count
(distinct (sal)) from EMP_USER B where A.sal<B.sal)

Is there any link between pr form(purchse requisition)and po form(purchase order)

2727

---

can u give guidance abt packages of plsql

2174

---

How to clone the database using RMAN back

2240

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2331

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1995

---

What is auto invoicing? : oracle accounts receivable

1160

---

Explain how to close periods in ar. : oracle accounts receivable

1313

---

What do you mean by Oracle MEDIA RECOVERY?

1227

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1349

---

What is Tax Categories?

2112

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2411

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223

---

What is the disk migration? what is the steps involved in oracle disk migration?

1222

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1047

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1281

---