SELECT T.TMPL_NO ,T.TMPL_CFNM ,T.PROD_LINE ,T.COIL_ROWS ,DECODE(DBMS_LOB.GETLENGTH(T.TMPL_EXCEL) , 0 , 'N' , 'Y') EXIT_YN ,REG_ID ,REG_DTIME ,MOD_ID ,MOD_DTIME ,EXT_NAME --文件扩展名 FROM TBB03_GRTE_TMPL T WHERE T.TMPL_NO LIKE ?||'%' ORDER BY T.PROD_LINE , T.TMPL_NO SELECT T.TMPL_EXCEL FROM TBB03_GRTE_TMPL T WHERE T.TMPL_NO = ? FOR UPDATE SELECT T.TMPL_EXCEL , T.TMPL_CFNM FROM TBB03_GRTE_TMPL T WHERE T.TMPL_NO = ? SELECT T.TMPL_EXCEL , T.TMPL_CFNM , T.EXT_NAME FROM TBB03_GRTE_TMPL T WHERE T.PROD_LINE = 'Q' INSERT INTO TBB03_GRTE_TMPL ( TMPL_NO ,TMPL_CFNM ,PROD_LINE ,COIL_ROWS ,TMPL_EXCEL ,REG_ID ,REG_DTIME ) VALUES(?,?,?,?,EMPTY_BLOB(),?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) UPDATE TBB03_GRTE_TMPL T SET T.TMPL_NO = ? ,T.TMPL_CFNM = ? ,T.PROD_LINE = ? ,T.COIL_ROWS = ? -- ,T.MOD_ID = ? -- ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.TMPL_NO = ? UPDATE TBB03_GRTE_TMPL T SET T.TMPL_EXCEL = ? ,T.EXT_NAME = ? ,T.MOD_ID = ? ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.TMPL_NO = ? DELETE FROM TBB03_GRTE_TMPL T WHERE T.TMPL_NO = ?