In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
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 is MO operating units. Why it need to to set this and where .
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
In unix Schell sript what is very 1st line to be wriiten .
how can we get odd numbered pages in output of a report
i have 100 pages output. i want to print 10 records per page in Template?
What is SET-OF-BOOKS?
In what situation u create the BPA.
What is GLOBAL TEMPORARY TABLE and It's significance ?
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
How can we import the data into a database using sql * loader?
what are the prerequisite set ups for inter organization transaction?
The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.