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 are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

How to link between inventory and OrderManagement.

1 Answers   Zensar,

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,

Can functions be overloaded ?

2 Answers  

why r u transer the data base tables to flat file and what is use

2 Answers  

How will U link GL with OU in Multi-org environment.

3 Answers   Convergys,

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

Who information?s?

2 Answers  

what are the pl/sql tables

1 Answers   IBM,

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

what is difference between API and Interface?

2 Answers   Infogain,