Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11382 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / laxman
select payment_id,payment_date from care_billing_payment
order by payment_id desc limit 10;
this query give latest 10 rows;
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
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 the use of lockboxes? : oracle accounts receivable
What is an Oracle database Partial Backup?
How to clone the database using RMAN back
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.
3. Steps in UAT?
where the dff data will be stored
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Explain the process of recievables in oracle financials. : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
