declare
s_tablename varchar2(10) default 'test';
s_var_arg varchar2(10);
begin
execute immediate 'select test_id from ' || s_tablename into s_var_arg;
dbms_output.put_line(s_var_arg);
end;
declare
s_tablename varchar2(10) default 'test';
s_var_arg varchar2(10);
begin
execute immediate 'select test_id from ' || s_tablename into s_var_arg;
dbms_output.put_line(s_var_arg);
end;