오라클 SQL테이블 백업 및 형상관리

CREATE OR REPLACE PROCEDURE SP_SQL_BAK
IS
/* SP_SQL_BAK
   내용  :  쿼리 형상관리
   개발자: LSJ
   확인쿼리:
-- B.GRP, B.ID, B.VER, B.SN, B.NAME, B.QUERY
SELECT *
  FROM TBL_SQL_BAK b
WHERE 1=1 
and grp in ('SAMPLE','SUA02011101') 
--AND ID = 'SAMPLE_SEARCH'
order by B.grp, B.id, B.ver, B.sn DESC
;
*/
    V_CNT           NUMBER := 0;
    V_SN            NUMBER := 0;

    V_GRP           TBL_SQL.GRP%TYPE;
    V_ID            TBL_SQL.ID%TYPE;
    V_VER           TBL_SQL.VER%TYPE;
    V_QUERY         TBL_SQL.QUERY%TYPE;

BEGIN

    -- 반영하기.
    FOR CUR_LIST IN (
        SELECT GRP,ID,VER
              ,NAME,QUERY,USE_YN,MEMO,CREATOR_ID,CREATED_TIME,MODIFIER_ID,MODIFIED_TIME
        FROM TBL_SQL    
    ) LOOP