In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.

Answer Posted / kavitha

select * from aa
where rownum <= 6
order last_updated_date desc

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different transaction clauses in AR?

1694


tell me the scenarios of the independent in reports

2133


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2210


Can u give the Documentation of Custom.pll in oracle apps

3105


What do you understand by concurrent programs?

706






Tell me how to debug the report?

734


do you know is it possible to run the interface without using oracle apps?

747


How is choreography different from orchestration?

757


What do you understand by soa and what are the benefits of using this architecture?

707


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

726


Do you know what are user profiles in apps. Any examples you can give?

749


where to define interorganization transaction charges and what are the different options?

2040


what are the prerequisites for costing transactions?

2748


What are file in oracle.

1901


In hierarchical structure of a database? we have write query from where we should start?

1795