dynamic query send multiple values dynamically
vpolasaOct 16 2008 — edited Oct 16 2008Hi all,
I'm trying to execute a dynamic query. Is it possible to send ename and deptno dynamically?
declare
v_sql varchar2(4000);
v_resultCol varchar2(100) := 'ename';
v_col varchar2(100) := 'deptno';
v_num number := 30;
v_count number;
begin
--v_sql := 'select '|| :v_resultCol ||' from emp where '|| :v_col || '= '|| :v_num;
v_sql := 'select count(ename) from emp where deptno = :a';
execute immediate v_sql into v_count using v_num;
dbms_output.put_line (v_count);
end;
/
Thanks