SELECT DISTINCT T.SPEC_ABBSYM LABEL , T.SPEC_ABBSYM VALUE FROM TBB01_KEY_PROD T ORDER BY T.SPEC_ABBSYM SELECT DISTINCT T.SPEC_STL_GRD LABEL , T.SPEC_STL_GRD VALUE FROM TBB01_KEY_PROD T ORDER BY T.SPEC_STL_GRD INSERT INTO TBB01_HCMAP_SPEC (PRIO_LEVL ,PRDNM_CD ,SPEC_ABBSYM ,SPEC_STL_GRD ,ORD_USE_TP ,THK_MIN ,THK_MAX ,WTH_MIN ,WTH_MAX ,C_PRDNM_CD ,C_SPEC_ABBSYM ,C_SPEC_STL_GRD ,C_ORD_USE_TP ,C_MAKE_THK ,C_MAKE_WTH ,REG_NM ,REG_DTIME) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) UPDATE TBB01_HCMAP_SPEC T SET PRIO_LEVL = ? ,PRDNM_CD = ? ,SPEC_ABBSYM = ? ,SPEC_STL_GRD = ? ,ORD_USE_TP = ? ,THK_MIN = ? ,THK_MAX = ? ,WTH_MIN = ? ,WTH_MAX = ? ,C_PRDNM_CD = ? ,C_SPEC_ABBSYM = ? ,C_SPEC_STL_GRD = ? ,C_ORD_USE_TP = ? ,C_MAKE_THK = ? ,C_MAKE_WTH = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE PRIO_LEVL = ? ,PRDNM_CD = ? ,SPEC_ABBSYM = ? ,SPEC_STL_GRD = ? ,ORD_USE_TP = ? ,THK_MIN = ? ,THK_MAX = ? ,WTH_MIN = ? ,WTH_MAX = ? DELETE FROM TBB01_HCMAP_SPEC T WHERE PRIO_LEVL = ? AND PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ? AND THK_MIN = ? AND THK_MAX = ? AND WTH_MIN = ? AND WTH_MAX = ?