SELECT '' SM_CD, 'ALL' SM_CFNM FROM DUAL UNION ALL SELECT DISTINCT T.QLTY_CD_2 SM_CD , T.QLTY_CD_2_NM SM_CFNM FROM TBB10_QLTY_CD T WHERE T.QLTY_CD_2_NM IS NOT NULL SELECT T.QLTY_CD_2 ,T.QLTY_OPE_CD ,T.QLTY_OPE_CFNM ,T.COMP_CAL ,T.QLTY_OPE_GRP ,T.QLTY_DIS_SEQ ,T.QLTY_DIS_LEN ,T.CRCT_REG ,T.OTHER_OPE_CD1 ,T.OTHER_OPE_CD2 ,T.OTHER_OPE_CD3 ,T.OTHER_OPE_CD4 ,T.EDIT_TP ,T.QLTY_CD_2 QLTY_CD_2_TP ,T.QLTY_OPE_CD QLTY_OPE_CD_TP FROM TBB10_QLTY_TMPL T WHERE T.QLTY_CD_2 = NVL(? , T.QLTY_CD_2) ORDER BY T.QLTY_CD_2 , T.QLTY_DIS_SEQ UPDATE TBB10_QLTY_TMPL T SET T.QLTY_CD_2 = ? ,T.QLTY_OPE_CD = ? ,T.QLTY_OPE_CFNM = ? ,T.COMP_CAL = ? ,T.QLTY_OPE_GRP = ? ,T.QLTY_DIS_SEQ = ? ,T.QLTY_DIS_LEN = ? ,T.CRCT_REG = ? ,T.OTHER_OPE_CD1 = ? ,T.OTHER_OPE_CD2 = ? ,T.OTHER_OPE_CD3 = ? ,T.OTHER_OPE_CD4 = ? ,T.MS_RMK = ? ,T.EDIT_TP = DECODE(? , NULL , 'N' , ?) WHERE T.QLTY_CD_2 = ? AND T.QLTY_OPE_CD = ? INSERT INTO TBB10_QLTY_TMPL ( QLTY_CD_2 ,QLTY_OPE_CD ,QLTY_OPE_CFNM ,COMP_CAL ,QLTY_OPE_GRP ,QLTY_DIS_SEQ ,QLTY_DIS_LEN ,CRCT_REG ,OTHER_OPE_CD1 ,OTHER_OPE_CD2 ,OTHER_OPE_CD3 ,OTHER_OPE_CD4 ,MS_RMK ,EDIT_TP ) VALUES ( ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ) DELETE FROM TBB10_QLTY_TMPL T WHERE T.QLTY_CD_2 =? AND T.QLTY_OPE_CD = ?