프로젝트

일반

사용자정보

게시판 » 업무공유 »

한국소방안전원 쿼리

송 경석이(가) 약 9시간 전에 추가함

INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB784319', 'CMTR0013', 'ERP_ID', 'kfsi0000', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783880', 'CMTR0013', 'ERP_ID', 'kfsi0001', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783900', 'CMTR0013', 'ERP_ID', 'kfsi0002', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783901', 'CMTR0013', 'ERP_ID', 'kfsi0101', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783902', 'CMTR0013', 'ERP_ID', 'kfsi0102', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783903', 'CMTR0013', 'ERP_ID', 'kfsi0201', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783904', 'CMTR0013', 'ERP_ID', 'kfsi0202', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783905', 'CMTR0013', 'ERP_ID', 'kfsi0301', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783906', 'CMTR0013', 'ERP_ID', 'kfsi0302', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783907', 'CMTR0013', 'ERP_ID', 'kfsi0401', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783908', 'CMTR0013', 'ERP_ID', 'kfsi0402', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783909', 'CMTR0013', 'ERP_ID', 'kfsi0501', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783910', 'CMTR0013', 'ERP_ID', 'kfsi0502', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783911', 'CMTR0013', 'ERP_ID', 'kfsi0601', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783912', 'CMTR0013', 'ERP_ID', 'kfsi0602', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783913', 'CMTR0013', 'ERP_ID', 'kfsi0701', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783914', 'CMTR0013', 'ERP_ID', 'kfsi0702', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783915', 'CMTR0013', 'ERP_ID', 'kfsi0801', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783916', 'CMTR0013', 'ERP_ID', 'kfsi0802', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783917', 'CMTR0013', 'ERP_ID', 'kfsi0901', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783918', 'CMTR0013', 'ERP_ID', 'kfsi0902', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783919', 'CMTR0013', 'ERP_ID', 'kfsi1001', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783920', 'CMTR0013', 'ERP_ID', 'kfsi1002', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783921', 'CMTR0013', 'ERP_ID', 'kfsi1101', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783922', 'CMTR0013', 'ERP_ID', 'kfsi1102', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783923', 'CMTR0013', 'ERP_ID', 'kfsi1201', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783924', 'CMTR0013', 'ERP_ID', 'kfsi1202', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783925', 'CMTR0013', 'ERP_ID', 'kfsi1301', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783926', 'CMTR0013', 'ERP_ID', 'kfsi1302', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783927', 'CMTR0013', 'ERP_ID', 'kfsi1401', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783928', 'CMTR0013', 'ERP_ID', 'kfsi1402', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('C2007215', 'CMTR0013', 'ERP_ID', 'kfsi1501', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('C2007216', 'CMTR0013', 'ERP_ID', 'kfsi1502', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB784319', 'CMTR0007', 'ERP_ID', 'kfsi0000', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783880', 'CMTR0007', 'ERP_ID', 'kfsi0001', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783900', 'CMTR0007', 'ERP_ID', 'kfsi0002', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783901', 'CMTR0007', 'ERP_ID', 'kfsi0101', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783902', 'CMTR0007', 'ERP_ID', 'kfsi0102', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783903', 'CMTR0007', 'ERP_ID', 'kfsi0201', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783904', 'CMTR0007', 'ERP_ID', 'kfsi0202', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783905', 'CMTR0007', 'ERP_ID', 'kfsi0301', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783906', 'CMTR0007', 'ERP_ID', 'kfsi0302', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783907', 'CMTR0007', 'ERP_ID', 'kfsi0401', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783908', 'CMTR0007', 'ERP_ID', 'kfsi0402', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783909', 'CMTR0007', 'ERP_ID', 'kfsi0501', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783910', 'CMTR0007', 'ERP_ID', 'kfsi0502', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783911', 'CMTR0007', 'ERP_ID', 'kfsi0601', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783912', 'CMTR0007', 'ERP_ID', 'kfsi0602', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783913', 'CMTR0007', 'ERP_ID', 'kfsi0701', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783914', 'CMTR0007', 'ERP_ID', 'kfsi0702', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783915', 'CMTR0007', 'ERP_ID', 'kfsi0801', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783916', 'CMTR0007', 'ERP_ID', 'kfsi0802', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783917', 'CMTR0007', 'ERP_ID', 'kfsi0901', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783918', 'CMTR0007', 'ERP_ID', 'kfsi0902', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783919', 'CMTR0007', 'ERP_ID', 'kfsi1001', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783920', 'CMTR0007', 'ERP_ID', 'kfsi1002', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783921', 'CMTR0007', 'ERP_ID', 'kfsi1101', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783922', 'CMTR0007', 'ERP_ID', 'kfsi1102', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783923', 'CMTR0007', 'ERP_ID', 'kfsi1201', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783924', 'CMTR0007', 'ERP_ID', 'kfsi1202', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783925', 'CMTR0007', 'ERP_ID', 'kfsi1301', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783926', 'CMTR0007', 'ERP_ID', 'kfsi1302', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783927', 'CMTR0007', 'ERP_ID', 'kfsi1401', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('CB783928', 'CMTR0007', 'ERP_ID', 'kfsi1402', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('C2007215', 'CMTR0007', 'ERP_ID', 'kfsi1501', to_char(now(), 'YYYYMMDDHH24MISS'));
INSERT INTO GSYS_ENV_SRV (BANK_USER_ID, SCR_NUM, ENV_COLUMN, ENV_VALUE,UPD_DT) VALUES ('C2007216', 'CMTR0007', 'ERP_ID', 'kfsi1502', to_char(now(), 'YYYYMMDDHH24MISS'));