In a table their 20 records.I had update 6 records???How can see and retrieve

Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
Suggest New Category

In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.

Question Posted / roshan

10 Answers
18165 Views
HCL, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

Answer / kavitha

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

Is This Answer Correct ?

15 Yes

2 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

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.

Is This Answer Correct ?

6 Yes

1 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

Answer / orchid

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

Is This Answer Correct ?

5 Yes

1 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

Answer / harinath

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

Is This Answer Correct ?

4 Yes

1 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

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);

Is This Answer Correct ?

2 Yes

0 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

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.

Is This Answer Correct ?

4 Yes

2 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

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

Is This Answer Correct ?

2 Yes

1 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

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.

Is This Answer Correct ?

1 Yes

0 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

Answer / harinath

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

Is This Answer Correct ?

0 Yes

0 No

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records..

Answer / ratnakar

select * from emp order by effective_start_date;