[오라클/PLSQL] 테이블 이름이 변경되는 DML문장

declare

  cursor cur_tables is

   select procedure_name,TABLE_NAME,OWNER, OWNER ||'.' || TABLE_NAME as full_name

  from DTABLE  

begin 

 open CUR_TABLES;

    LOOP

    FETCH CUR_TABLES into V_PROCEDURE_NAME,V_TABLE_NAME,V_OWNER,V_FULL_NAME;

   exit when cur_tables%NOTFOUND;

  

    --    EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';

    --    EXECUTE IMMEDIATE 'ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUE';

  

    V_STR := 'insert /*+ APPEND  */ into '|| V_FULL_NAME ||

    ' DEST SELECT * FROM ' || v_full_name;

    execute immediate v_str;

    

  end loop;

 close CUR_TABLES;

end 

/

방법이야 많이 있겠습니다만, 여튼 이런거