SELECT T.SM_CD VALUE , T.SM_CFNM LABEL FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002' = NVL(?, 'R0-000000A') AND SUBSTR(TE.COIL_NO, 1, 10) <= NVL(?, 'R9-999999A') ]]> SELECT * FROM TBB02_DCS_TECH T WHERE T.COIL_NO = ? AND T.PROD_CD = ? INSERT INTO TBB02_DCS_TECH( COIL_NO, PROD_CD, PROD_DCS_RST, PROD_DCS_TP, PROD_DCS_DTIME, REG_ID, REG_DTIME ) VALUES(?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')) UPDATE TBB02_DCS_TECH SET PROD_DCS_RST = ? --判定结果 ,PROD_DCS_TP = ? --判定类型 ,PROD_DCS_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') --判定时间 ,REG_ID = ? --修改人 ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') --修改日期 WHERE COIL_NO = ? --钢卷号 AND PROD_CD = ? --规范代码