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
Explain what are the tables of auto invoice?
Do you know what is applysys in oracle application database schema, what is apps?
What are the Standard Reports and Forms in HRMS?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is sca and how is it useful?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What are the different components you should consider while defining a responsibility in oracle apps?
testing tools?
What is count(*) from po_vendors(any table)?
tell me the scenarios of the independent in reports
What are the benefits of using soa architecture?
What do you understand by a set of books?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
How do you register report in oracle apps?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP