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 the types of validation?

904

---

Differentiate apps schema from other schemas?

863

---

Is there any documentation on how to setup an organization?

821

---

What is mrc? Explain its uses

920

---

Define about key flexfiled ?

781

---

Explain about security attributes?

845

---

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

971

---

Can you send blob attachments via workflow notifications?

1103

---

Explain Rule based optimization in oracle apps?

821

---

Where are tables created?

854

---

How will you open a bc4j package in jdeveloper?

918

---

Hi , I'm a Oracle Apps Technical Consultant.Looking for Functional Training on specific modules like INV,OM,PO,AP,AR,GL .Can you please let me know any trainer/institute details for the same.

1330

---

What is data migration?

792

---

Define sql loader ?

916

---

I want to setup additional organizations, do I have to setup multiorg?

784

---