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 / orchid
Since the following sql
select * from aa
where rownum <= 6
order last_updated_date desc
will return random 6 rows and then the
order by 'last_updated_date desc' will only apply to
selected 6 records, so you won't get latest updated 6
records.
Please correct me if I was wrong.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the different transaction clauses in AR?
Is soa a part of oracle fusion middleware?
what are the balancing segments in AR?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
how to print multi lay outs,muti currency,muti language in xml publisher
Which oracle apps version you are very confident in?
In oracle application how do you debug or trace errors?
What is instead of trigger in where we will use?
q)what are the validations in sql*loader
What do you understand by soa and what are the benefits of using this architecture?
what is pay run id ?
How many schemas we have? how many you have used?
do you know is it possible to run the interface without using oracle apps?
Explain oracle apps architecture.
tell me the scenarios of the independent in reports