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 and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers  

---

How can you achieve loose coupling in soa framework?

0 Answers  

---

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,

---

List the various types of value set.

0 Answers  

---

how can u find the status in po?

1 Answers  

---

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

2 Answers   Deloitte, Oracle,

---

diff between key and descriptive flexfield.

4 Answers   Convergys,

---

how can u link a org-id with a responsibility in reports?

2 Answers   TCS,

---

tell me the scenarios of between pages in reports

5 Answers  

---

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,

---

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,

---

After deploying like forms,reports into server how we connect this forms,reports to web?

1 Answers   IBM,

---