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;

Tell me where we find the status of order information?

1115

---

What do you understand by concurrent programs?

1048

---

How can we import the data into a database using sql * loader?

1139

---

tell me the scenarios of the independent in reports

2456

---

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

1060

---

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

2184

---

List the various types of value set.

1036

---

What does appl_top directory contain?

1088

---

how do you describe O2C along with tables

2739

---

what are the balancing segments in AR?

2060

---

Can we create tables in apps schema?

1098

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3026

---

where to define interorganization transaction charges and what are the different options?

2386

---

do you know is it possible to run the interface without using oracle apps?

1082

---

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?

1041

---