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

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

2127

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2196

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2265

---

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

---

Can we modify approve purchase order?if yes what is navigation?

2010

---

which one is currently in used software cmpanies.

2155

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1157

---

Explain the payment term in ar. : oracle accounts receivable

1106

---

HOW TO SPOT AHIERARCHY?

2297

---

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

1145

---

What is Tax Categories?

2113

---

What is the use of lockboxes? : oracle accounts receivable

1208

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1777

---

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?

2412

---

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

2333

---