select * from aa,fnd_sessions ses where ses.effective

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 / vijaya

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

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

Please Help Members By Posting Answers For Below Questions

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2242

In support project one ticket alloted which steps follows manualy tell me ?

2650

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2110

Do you know what is applysys in oracle application database schema, what is apps?

1167

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3042

what is global tempory table?

7185

testing tools?

2222

What is instead of trigger in where we will use?

1155

Is soa a part of oracle fusion middleware?

1073

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1095

In oracle application how do you debug or trace errors?

1091

What is sca and how is it useful?

1103

how to print multi lay outs,muti currency,muti language in xml publisher

12255

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2602

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2086