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?
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
Explain how to close periods in ar. : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
How to clone the database using RMAN back
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
What is auto invoicing? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
how to write customizations in po
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
What is the difference between conversions and interfaces? : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What are different types of transactions in ar? : oracle accounts receivable