Answer / kavitha

select * from aa
where rownum <= 6
order last_updated_date desc

Answer / saritha

If the table is an apps table, then it can be determined
based on the last_update_date of the record. You can query
the table based on the last_update_date column.

Answer / orchid

select * from (select * from aa
order by last_updated_date desc)
where rownum <= 6;

Answer / harinath

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

Answer / ratnakar

if u know updated date then following query will work

select * from emp where effecive_start_date = (select
sysdate from dual);


or

select * from emp where effective_start_date = (select
to_date(dateof update,'dd-mon-yy') from dual);

Answer / fly-by

You can't. The effective date isn't necessarily the date
of the update, so testing for it won't yield the result you
seek. Unless your table has a "date_updated" column, you
haven't anything to filter on.

Answer / vijaya

select * from aa,fnd_sessions ses
where ses.effective_date between aa.effective_start_date
and aa.effective_end_date

or

select * from aa
where sysdate between aa.effective_start_date and
aa.effective_end_date

Answer / 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.

Answer / harinath

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

Answer / ratnakar

select * from emp order by effective_start_date;

Tell me how to find the custom directory in front end?

0 Answers  

why we can use synonym?

6 Answers  

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

0 Answers  

what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,

Can u define operating units inplace of inventory?

2 Answers  

what is lexical parameter?

3 Answers   TCS,

what are the receipt types in Po?

2 Answers   Evosys, UST,

WHAT IS REFCURSOR IN ORACLE ?

6 Answers  

hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers   BirlaSoft,

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

What is FORWARD DECLARATION in Packages?

6 Answers   British Telecom BT, HCL, Tech Mahindra,

API?s FOR CUSTOMER INTERFACE? Tell me some API's?

1 Answers