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);

What is oracle soa suite and what are its different components?

1200

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2197

---

List the various types of value set.

1072

---

Can you differentiate between mediator and osb?

1127

---

Do you know where we can check the status of po?

1256

---

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

2309

---

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

2643

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3648

---

Do you know what are user profiles in apps. Any examples you can give?

1084

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3043

---

What are the different components of soa suite?

1195

---

How is choreography different from orchestration?

1117

---

tell me the scenarios of the independent in reports

2489

---

what is pay run id ?

2182

---

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

12255

---