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
testing tools?
What is the concept of soa governance?
where to define interorganization transaction charges and what are the different options?
What are the different components you should consider while defining a responsibility in oracle apps?
Plz anybody send me Technical specification for AP Interface
what are the prerequisites for costing transactions?
how to print multi lay outs,muti currency,muti language in xml publisher
Tell me how to debug the report?
How do you register report in oracle apps?
What do you understand by concurrent programs?
Can we create tables in apps schema?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Explain what are the tables of auto invoice?
tell my any difficult situtation you solved in your experience in your company?
how do you describe O2C along with tables