SELECT T.* , T.LG_CD LG_CD_1, T.SM_CD SM_CD_1 FROM TBB10_COMMCD T WHERE T.LG_CD LIKE ?||'%' ORDER BY T.LG_CD , T.CD_SEQ UPDATE TBB10_COMMCD T SET T.LG_CD = ? ,T.SM_CD = ? ,T.LG_NM = ? ,T.SM_CFNM = ? ,T.CD_SEQ = ? ,T.USED_YN = NVL(? , 'Y') ,T.CD_DESC = ? ,T.EDIT_TP = NVL(? , 'Y') ,T.MOD_ID = ? ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.LG_CD = ? AND T.SM_CD = ? AND T.EDIT_TP = 'Y' INSERT INTO TBB10_COMMCD ( LG_CD ,SM_CD ,LG_NM ,SM_CFNM ,CD_SEQ ,USED_YN ,CD_DESC ,EDIT_TP ,REG_ID ,REG_DTIME ) VALUES (?,?,?,?,?,NVL(?,'Y'),?,NVL(? ,'Y'),?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) DELETE FROM TBB10_COMMCD WHERE LG_CD =? AND SM_CD = ? AND EDIT_TP = 'Y'