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 / harinath

select *from emp
where rownum<=6
order by last_updated_date desc

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know where we can check the status of po?

647


In oracle application how do you debug or trace errors?

649


What does appl_top directory contain?

664


What are the different components of soa suite?

734


what is the differences between internal requisition and internal sales order?

2167






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

621


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1988


How is choreography different from orchestration?

670


what are the balancing segments in AR?

1664


What is oracle soa suite and what are its different components?

662


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

3096


In hierarchical structure of a database? we have write query from where we should start?

1721


How do you register report in oracle apps?

638


Can we create tables in apps schema?

649


Explain oracle apps architecture.

786