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


Please Help Members By Posting Answers For Below Questions

What does appl_top directory contain?

739


How can a process be deployed in soa?

799


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

729


How to create a purchase order without a requisition?

738


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1874






tell me the scenarios of the independent in reports

2221


What is oracle soa suite?

861


Can you differentiate between mediator and osb?

730


What do you understand by soa?

780


Can you define an erp system?

762


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


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

1736


Plz anybody send me Technical specification for AP Interface

2148


what are the balancing segments in AR?

1733


How can you achieve loose coupling in soa framework?

827