SELECT SM_CFNM LABEL , SM_CD VALUE FROM TBZ00_COMMCD WHERE LG_CD='B01001' ORDER BY SM_CD SELECT SM_CD LABEL , SM_CD VALUE FROM TBZ00_COMMCD WHERE LG_CD='B01001' ORDER BY SM_CD SELECT SM_CD LABEL , SM_CD VALUE FROM TBZ00_COMMCD WHERE LG_CD='B01119' ORDER BY SM_CD SELECT DISTINCT SPEC_STL_GRD LABEL ,SPEC_STL_GRD VALUE FROM TBB01_SPEC_INGR ORDER BY SPEC_STL_GRD SELECT DISTINCT DEV_SPEC_CD LABEL ,DEV_SPEC_CD VALUE FROM TBB01_SPEC_DEL ORDER BY DEV_SPEC_CD SELECT SM_CFNM LABEL , SM_CD VALUE FROM TBZ00_COMMCD WHERE LG_CD = 'A01007' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM SELECT T.SM_CFNM SM_CD , T.SM_CFNM SM_CD FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01118' INSERT INTO TBB01_KEY_DEL( PRDNM_CD --品名 , SPEC_ABBSYM --标准号 , SPEC_STL_GRD --标准钢号 , ORD_USE_TP --订单用途 , DEV_SPEC_CD --交付条件规格 , DEV_DGR_CD --等级代码 , REG_ID --录入人 , REG_DTIME --录入日期 ) VALUES(?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) UPDATE TBB01_KEY_DEL SET PRDNM_CD = ? --品名 , SPEC_ABBSYM = ? --标准号 , SPEC_STL_GRD = ? --标准钢号 , ORD_USE_TP = ? --订单用途 , DEV_SPEC_CD = ? --交付条件规格 , DEV_DGR_CD = ? --等级代码 , MOD_ID = ? --录入人 , MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') --录入日期 WHERE PRDNM_CD = ? --品名 AND SPEC_ABBSYM = ? --标准号 AND ORD_USE_TP = ? --订单用途 AND SPEC_STL_GRD = ? --标准钢号 DELETE FROM TBB01_KEY_DEL WHERE PRDNM_CD = ? --品名 AND SPEC_ABBSYM = ? --标准号 AND SPEC_STL_GRD = ? --标准钢号 AND ORD_USE_TP = ? --订单用途