Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18334 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 |
In interface how u find errors and how to solve. How to fix it?
Oder of firing triggers in form
where is setup of business group done?
can we execute one concurrent program through another concurrent program?
Tell me some errors names and number what u got while developing the reports?
FLEX FIELDS?
What is set function in sql .E.g.What is difference between union and union all
what is difference between po_headers_all and po_headers
what is the defference between credit memo and debit memo
What is Value Set?
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*/
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
Oracle Apps Technical 
