Answer Posted / 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);

Can you differentiate between mediator and osb?

730

---

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

11071

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1689

---

how do you describe O2C along with tables

2391

---

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

1859

---

---

What do you understand by soa?

780

---

tell my any difficult situtation you solved in your experience in your company?

1960

---

In oracle application how do you debug or trace errors?

729

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2689

---

Plz anybody send me Technical specification for AP Interface

2148

---

How is choreography different from orchestration?

757

---

q)what are the validations in sql*loader

1823

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

746

---

What do you understand by soa and what are the benefits of using this architecture?

707

---

what is the differences between internal requisition and internal sales order?

2260

---