How to pass data into EXECUTE_IMMEDIATE statement in plsql
body ?

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;

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me how to debug the report?

631


In support project one ticket alloted which steps follows manualy tell me ?

2218


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1749


What is a flexfield? List out its types.

657


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

1512






How many schemas we have? how many you have used?

1604


Explain oracle apps architecture.

756


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

1562


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2586


q)what are the validations in sql*loader

1735


What do you understand by a set of books?

641


What is count(*) from po_vendors(any table)?

637


tell me the scenarios of the independent in reports

2039


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

3071


How to create a purchase order without a requisition?

617