Answer Posted / sandeep

syntax: select <rownum>,<c.. n.. 2>,<c..n..3>
from<tablename>
group by<rownum>,<c.n.2>,<c.n.3>
having rownum=&n
eg:
select rownum,ename,empno from emp
group by rownum,ename,empno
having rownum=&8

what are basic modules required to implement oracle application in any oraganisation?

2259

---

What is the mandatory setup in cyclecount ?

2807

---

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

2380

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2066

---

How would you determine what sessions are connected and what resources they are waiting for?

2178

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2511

---

What is the sql query to find the employee who has Nth maximum salary?

5428

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1190

---

Explain the use of table functions.

2583

---

Explain the payment term in ar. : oracle accounts receivable

1151

---

How to clone the database using RMAN back

2313

---

difference of using cursor for loop and open,fetch,close.which one is better

1864

---

What is the difference between recovery and restoring of the oracle database?

1291

---

how to write customizations in po

1660

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2565

---