A Table has 10,000 records,How can i get latest 10 dates
from the table.so that i can only store those 10 records
in to my Resultset Object,to reduce load on my app?
- 7 Answers
- 10394 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajesh
select * from(select * from table_name order by date_column
desc) where rowid<=10
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How would you determine what sessions are connected and what resources they are waiting for?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
as a technical developer in oracle applications which type errors feced in your experience sofar
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Explain prerequisites and post activities of oracle database installation
Could you please let me know the interfaces in OM / FA??
Give two methods you could use to determine what DDL changes have been made.
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
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is the difference between oracle media recovery and crash recovery?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
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.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
