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?

1598


what is global tempory table?

6284


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

1514


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2085


Which oracle apps version you are very confident in?

701






What are the Standard Reports and Forms in HRMS?

1766


tell me the scenarios of the independent in reports

2102


testing tools?

1747


Do you know what is applysys in oracle application database schema, what is apps?

668


what are the balancing segments in AR?

1645


how to print multi lay outs,muti currency,muti language in xml publisher

10715


How to move the one file from one instance to another instance? And your scripts also?

608


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3073


What is the concept of soa governance?

763


how can i print random rows in plsql table

1929