SELECT T.SM_CD , T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01007' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM SELECT DISTINCT T.SPEC_ABBSYM , T.SPEC_ABBSYM SPEC_ABBSYM_ FROM TBB01_KEY_PROD T ORDER BY T.SPEC_ABBSYM SELECT DISTINCT T.SPEC_STL_GRD , T.SPEC_STL_GRD SPEC_STL_GRD_ FROM TBB01_KEY_PROD T ORDER BY T.SPEC_STL_GRD SELECT PROD_LINE ,PRDNM_CD ,SPEC_ABBSYM ,SPEC_STL_GRD ,ORD_USE_TP ,THK_MIN ,THK_MAX ,WTH_MIN ,WTH_MAX ,PROD_LINE PROD_LINE_1 ,PRDNM_CD PRDNM_CD_1 ,SPEC_ABBSYM SPEC_ABBSYM_1 ,SPEC_STL_GRD SPEC_STL_GRD_1 ,ORD_USE_TP ORD_USE_TP_1 ,THK_MIN THK_MIN_1 ,THK_MAX THK_MAX_1 ,WTH_MIN WTH_MIN_1 ,WTH_MAX WTH_MAX_1 ,NEW_PROC_TYPE ,NEW_PROC_DESC ,REG_ID ,REG_DTIME ,MOD_ID ,MOD_DTIME FROM TBB01_NEW_PROD T WHERE T.SPEC_STL_GRD LIKE ?||'%' INSERT INTO TBB01_NEW_PROD ( PROD_LINE ,PRDNM_CD ,SPEC_ABBSYM ,SPEC_STL_GRD ,ORD_USE_TP ,THK_MIN ,THK_MAX ,WTH_MIN ,WTH_MAX ,NEW_PROC_TYPE ,NEW_PROC_DESC ,REG_ID ,REG_DTIME ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) UPDATE TBB01_NEW_PROD T SET PROD_LINE = ? ,PRDNM_CD = ? ,SPEC_ABBSYM = ? ,SPEC_STL_GRD = ? ,ORD_USE_TP = ? ,THK_MIN = ? ,THK_MAX = ? ,WTH_MIN = ? ,WTH_MAX = ? ,NEW_PROC_TYPE = ? ,NEW_PROC_DESC = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE PROD_LINE = ? 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 = ? DELETE FROM TBB01_NEW_PROD T WHERE PROD_LINE = ? 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 = ?