Answer Posted / ravikumar.s

select * from (select * from tblname order by datecolumn
asc) where rownum<=10;

There is no keyword in oracle like limit, only we can fetch
through rownum

in mysql only this limit is available
ex: select col from tbl limit 20;

in sql server we use Top keyword instead of limit;

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2256

---

Why more redos are generated when the oracle database is in begin backup mode?

1118

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1145

---

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2172

---

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

1990

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2304

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1269

---

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

1272

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3932

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2068

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2133

---

What is supporting issues GL AP and AR?

2533

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2109

---

Are These Dff's Flexible?

1166

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2273

---