create or replace procedure dyn_updatesal(p_empno employees.employeeid%type,
p_sal number) as
v_str varchar2(100);
begin
v_str := 'update employees set salary = ' || p_sal ||
'where employeeid = ' || p_empno;
execute immediate v_str;
end dyn_sql_test;
p_sal number) as
v_str varchar2(100);
begin
v_str := 'update employees set salary = ' || p_sal ||
'where employeeid = ' || p_empno;
execute immediate v_str;
end dyn_sql_test;