SELECT DISTINCT SIR.SPEC_STL_GRD LABEL , SIR.SPEC_STL_GRD VALUE FROM TBB01_SPEC_INGR SIR ORDER BY SIR.SPEC_STL_GRD SELECT DISTINCT A.SM_CD LABEL --标准名称 ,A.SM_CD VALUE FROM TBZ00_COMMCD A WHERE LG_CD = 'B01001' ORDER BY A.SM_CD SELECT * FROM TBB01_SEQ_PROD T ORDER BY T.DISPLAY_SEQ SELECT SPEC_ABBSYM FROM TBB01_SPEC_TECH WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND PROD_CD = ? SELECT T1.PROD_CD ,T1.PROD_CD_CFNM ,T1.PROD_TYPE ,T1.DCS_SYM ,T2.PROD_VAL ,T2.MEMO ,T2.PROD_VAL_EXP1 ,T2.PROD_VAL_EXP2 ,T2.PROD_VAL_EXP3 FROM TBB01_SEQ_PROD T1 , TBB01_SPEC_TECH T2 WHERE T1.PROD_CD = T2.PROD_CD(+) AND T2.PRDNM_CD(+) = ? AND T2.SPEC_ABBSYM(+) = ? AND T2.SPEC_STL_GRD(+) = ? ORDER BY DECODE(T2.PROD_VAL, NULL , 1 , 0) , T1.DISPLAY_SEQ INSERT INTO TBB01_SPEC_TECH( --规范代码录入 PRDNM_CD, SPEC_ABBSYM, SPEC_STL_GRD, PROD_CD, PROD_TYPE, DCS_SYM, PROD_VAL, MEMO, REG_ID, REG_DTIME ) VALUES(?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')) UPDATE TBB01_SPEC_TECH SET PROD_VAL = ?, MEMO = ?, MOD_ID = ?, MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') --修改日期 WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND PROD_CD = ? DELETE FROM TBB01_SPEC_TECH WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD=? DELETE FROM TBB01_SPEC_TECH WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD= ? AND PROD_CD = ?