Answer Posted / sonu

Answer of Ravikumar.s is almost write but there is slightly
mistake, he should write 'desc' keyword instead of 'asc'
because question for latest records not for the oldest
records. So, the correct answer is

select * from (select * from tablename order by datecolumn
desc) where rownum<=10;


One keyword makes the statement and result write or wrong
so, use these carefully.

Explain the use of table functions.

2411

---

8. Supporting AP, AR and GL?

2274

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17540

---

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

1108

---

Could you please let me know the interfaces in OM / FA??

2210

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1164

---

What is auto invoicing? : oracle accounts receivable

1106

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2460

---

What is the difference between oracle media recovery and crash recovery?

1135

---

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

2164

---

What is mrc and what is its use? : oracle accounts receivable

1131

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2285

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1017

---

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

5244

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2329

---