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;

what is instead of trigger in where u will use?

2 Answers   TCS,

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

In what situation u create the BPA.

2 Answers   Accenture,

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

0 Answers   Cap Gemini,

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

what is the database size you used?

1 Answers   FIS,

What is the concept of soa governance?

0 Answers  

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

what are the types of interfacing?

3 Answers   TCS,