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

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2584


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

1993


can we get profile values in report without using user exists is it possible how?

2407


Tell me where we find the status of order information?

753


Are you familiar with internet architecture of oracle apps 11i?

729






What are the different components of soa suite?

817


What are file in oracle.

1901


What does appl_top directory contain?

739


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1782


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1736


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

2260


how do you describe O2C along with tables

2391


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

747


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

1705


What are the benefits of using soa architecture?

802