select replace('rdw_zjt_boss_8',8,'rec_ind') from dual;
create or replace procedure my_test_procedure is rec_ind number; v_run_log varchar2(100); begin rec_ind := 8; --select vc_mobileno into v_run_log from rdw_zjt_boss_8 where rownum < 2; execute immediate 'select vc_mobileno from rdw_zjt_boss_'||rec_ind||' where rownum < 2' into v_run_log; dbms_output.put_line(v_run_log); end;
create or replace procedure my_test_procedure
is
rec_ind number;
v_run_log varchar2(100);
begin
rec_ind := 8;
--select vc_mobileno into v_run_log from rdw_zjt_boss_8 where rownum < 2;
execute immediate 'select vc_mobileno from rdw_zjt_boss_'||rec_ind||' where rownum < 2' into v_run_log;
dbms_output.put_line(v_run_log);
end;