/* 01.03.2019 1 Корекция на първи вариант на актуализацията */ DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'NF988'); DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'NF991'); DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'NF992'); DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'NF993'); DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'NF994'); DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'NF995'); DELETE FROM NHIF_MAPPING WHERE (NZOK_CODE = 'AF454'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'NF988', '2560'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'NF991', '15307'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'NF992', '3396'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'NF993', '3397'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'NF994', '3398'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'NF995', '3399'); INSERT INTO NHIF_MAPPING (ID, NZOK_CODE, CPR_CODE) VALUES (GEN_ID(NHIF_MAPPING_ID, 1), 'AF454', '1400');