In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
- 10 Answers
- 15346 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kavitha
select * from aa
where rownum <= 6
order last_updated_date desc
| Is This Answer Correct ? | 15 Yes | 2 No |
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 |
Answer / orchid
select * from (select * from aa
order by last_updated_date desc)
where rownum <= 6;
| Is This Answer Correct ? | 5 Yes | 1 No |
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 |
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 |
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 |
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 |
Answer / ratnakar
select * from emp order by effective_start_date;
| Is This Answer Correct ? | 1 Yes | 2 No |
What are profile options?
while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?
Do you know where we can check the status of po?
how many groups we can create for query?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
After deploying like forms,reports into server how we connect this forms,reports to web?
What is template?
Cycle of requestion to receving transaction.
In which directory your flatfile is given?if u connected different instance where it is find?
Define MultiOrg Structure
what is the differences between internal requisition and internal sales order?
How You Will display the key flexifields in your report
Oracle Apps Technical 
