Answer Posted / rashmiraj

SELECT COL1,COL2,ROWNUM
FROM (SELECT COL1,COL2 FROM TABLE ORDER BY COL1 DESC)
WHERE ROWNUM<=&A;

as for example........

select ename,job,sal,rownum
from (select ename,job,sal from emp order by sal desc)
where rownum <=3;

Define erp (enterprise resource planning) ?

937

---

What responsibility do I need to use to setup organization?

946

---

What is multi org architecture?

992

---

Explain the uses of mrc?

987

---

Explain the mechanisms to trace the document manager?

871

---

What are cycles of ar?

922

---

Explain the types of flexfields?

945

---

There is currently a list of predefined auto cash rules, however I am wanting to know if you can customise and create a cash rule to specifically target an aging bucket i.e. 30 days

1369

---

Which are the kinds of report triggers?

1014

---

When my organization hierarchy changes, can I move an organization from one set of books or legal entity to another?

986

---

What is the significance of profile option “responsibility trust level”.

1118

---

Explain Rule based optimization in oracle apps?

920

---

What are Quick pick and quick codes

1007

---

What are the types of journal entries?

919

---

Define set – of books?

1002

---