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
Tell me how to debug the report?
In support project one ticket alloted which steps follows manualy tell me ?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What is a flexfield? List out its types.
is it possible to run the interface without using oracle apps?
How many schemas we have? how many you have used?
Explain oracle apps architecture.
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
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
q)what are the validations in sql*loader
What do you understand by a set of books?
What is count(*) from po_vendors(any table)?
tell me the scenarios of the independent in reports
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
How to create a purchase order without a requisition?