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 Standard Reports and Forms in HRMS?

1780


What is count(*) from po_vendors(any table)?

647


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2137


What do you understand by soa?

703


Tell me where we find the status of order information?

681






Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

654


Plz anybody send me Technical specification for AP Interface

2032


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

3006


can we use look up type instead of a pofile option?or valueset?is it possible how?

1796


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

685


tell me the scenarios of the independent in reports

2063


what are the balancing segments in AR?

1664


How many schemas we have? how many you have used?

1628


What are do's and dont's of Interface?

1917


What are the different components you should consider while defining a responsibility in oracle apps?

662