Answer Posted / eldho

Hope this pice of code explains:

declare
v_query VARCHAR2 (200);
v_employee_name VARCHAR2 (50);
BEGIN
v_query := 'SELECT emp_name from employees where emp_id =
102';
EXECUTE IMMEDIATE v_query
INTO v_employee_name;
DBMS_OUTPUT.put_line ('Emp Name is ' || v_employee_name);
END;

Are you familiar with internet architecture of oracle apps 11i?

1072

---

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

2054

---

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

2323

---

What do you understand by concurrent programs?

1114

---

Plz anybody send me Technical specification for AP Interface

2571

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2640

---

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?

14985

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3071

---

How to create a purchase order without a requisition?

1205

---

What is a flexfield? List out its types.

1179

---

what is the difference between request group and request security in oracle apps?

5916

---

how can i print random rows in plsql table

2510

---

what are the prerequisites for costing transactions?

3151

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2398

---

Is soa a part of oracle fusion middleware?

1113

---