SELECT DISTINCT SIR.SPEC_STL_GRD LABEL , SIR.SPEC_STL_GRD VALUE FROM TBB01_SPEC_INGR SIR ORDER BY SIR.SPEC_STL_GRD INSERT INTO TBB01_MILL_TECH( --规范代码录入 SPEC_STL_GRD, ORD_THK_MIN, ORD_THK_MAX, THK_MIN, THK_MAX, SEQ_NO ) VALUES(?,?,?,?,?,(SELECT NVL(MAX(SEQ_NO),0) + 1 FROM TBB01_MILL_TECH)) SELECT DISTINCT T.SPEC_STL_GRD --规格钢号 FROM tbb01_mill_tech T WHERE T.SPEC_STL_GRD = DECODE(?, NULL, T.SPEC_STL_GRD, ?) ORDER BY T.SPEC_STL_GRD SELECT t.ord_thk_min, t.ord_thk_max, t.thk_min, t.thk_max,t.seq_no --规格钢号 FROM tbb01_mill_tech T WHERE T.SPEC_STL_GRD = ? ORDER BY T.ORD_THK_MIN asc SELECT * FROM (select get_tbf02_thkmin(?,?) AA from dual)T WHERE T.AA IS NOT NULL SELECT * FROM (select get_tbf02_thkmax(?,?) AA from dual)T WHERE T.AA IS NOT NULL update tbb01_mill_tech t set t.ord_thk_min = ?, t.ord_thk_max = ?, t.thk_min = ?, t.thk_max = ? where t.seq_no = ? delete tbb01_mill_tech t where T.SPEC_STL_GRD = ? delete tbb01_mill_tech t where T.SEQ_NO = ?