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

Answer / m.n

declare
v_query VARCHAR2 (200);
v_inv_item_id VARCHAR2 (50);
BEGIN
v_query := 'SELECT inventory_item_id from
mtl_onhand_quantities_detail where inventory_item_id =107';
EXECUTE IMMEDIATE v_query
INTO v_inv_item_id;
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
exception
when others then
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
END;

what is the use of placeholer column?

3 Answers  

---

what is aim methodolozy

1 Answers   Wipro,

---

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

0 Answers  

---

What are do's and dont's of Interface?

0 Answers  

---

how many layout sections are tehre in layout editor?

1 Answers  

---

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

0 Answers  

---

What do you understand by concurrent programs?

0 Answers  

---

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

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

0 Answers  

---