自个的sql备份

CREATE OR REPLACE PROCEDURE EMS_EMPL_INFO_BACKUP AS
BEGIN
INSERT INTO EMS_EMPL_INFO_WEEK
SELECT EMS_EMPL_INFO_BACKUP_INFO.NEXTVAL, T1.*, T2.MYWEEK, SYSDATE
FROM (SELECT *
FROM EMS_EMPL_INFO
WHERE EMS_EMPL_INFO.RES_STATUS IN (1, 2, 3)) T1,
(SELECT DATE_DIM.FISCAL_WEEK MYWEEK
FROM DATE_DIM
WHERE DATE_DIM.DAY_NAME &＃61; TO_CHAR(SYSDATE, &＃39;yyyy-mm-dd&＃39;)) T2;
COMMIT;
END EMS_EMPL_INFO_BACKUP;