In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
- 10 Answers
- 15403 Views
- HCL, TCS, I also Faced
- E-Mail Answers
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
In support project one ticket alloted which steps follows manualy tell me ?
What do you understand by concurrent programs?
What do you understand by soa?
Do you know what is applysys in oracle application database schema, what is apps?
Tell me where we find the status of order information?
what is the difference between request group and request security in oracle apps?
Can you define an erp system?
Can you explain the difference between architecture followed in 10g & 11g?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
What are the benefits of using soa architecture?
what is global tempory table?
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
what are the different transaction clauses in AR?
Is soa a part of oracle fusion middleware?
what are the prerequisites for costing transactions?
