In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
Answer Posted / 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 |
Post New Answer View All Answers
In hierarchical structure of a database? we have write query from where we should start?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
What is a flexfield? List out its types.
Tell me how to debug the report?
Do you know what is applysys in oracle application database schema, what is apps?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by concurrent programs?
What do you understand by soa and what are the benefits of using this architecture?
What are the different components you should consider while defining a responsibility in oracle apps?
where to define interorganization transaction charges and what are the different options?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What are do's and dont's of Interface?
What does appl_top directory contain?
How can you achieve loose coupling in soa framework?