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
List the various types of value set.
how to print multi lay outs,muti currency,muti language in xml publisher
What are the benefits of using soa architecture?
What are the different components of soa suite?
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
please send me forms, xml pulisher questions,answers
Is soa a part of oracle fusion middleware?
Do you know where we can check the status of po?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Do you know what is applysys in oracle application database schema, what is apps?
Can you define an erp system?
Can we create tables in apps schema?
how can i print random rows in plsql table
What do you understand by soa?
Explain what are the tables of auto invoice?