SELECT DISTINCT T.SPEC_STL_GRD SM_CFNM, T.SPEC_STL_GRD SM_CD FROM TBB01_SPEC_INGR T SELECT 'False' CHK ,T.STL_GRD , T.DAT_TYPE , T.DAT_TYPE EDIT_TYPE , T.ROOM1 , T.ROOM2 , T.ROOM3 , T.ROOM4 , T.ROOM5 , T.ROOM6 , T.ROOM7 , T.ROOM8 , T.ROOM9 , T.ROOM10 , T.ROOM11 , T.ROOM12 , T.ROOM13 , T.ROOM14 , T.ROOM15 , T.ROOM16 , T.ROOM17 , T.ROOM18 FROM C_TBF02_LTYS T WHERE T.DAT_TYPE =? UPDATE c_tbf02_ltys SET PROD_CD = ? --更新后规范编码 , DISPLAY_SEQ = ? --显示顺序 , PROD_TYPE = ? --代码类型 , PROD_CD_CFNM = ? --中文名称 , DCS_SYM = ? --判定符号 , MOD_ID = ? --修改人 , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') --修改日期 WHERE STL_GRD = ? --更新前规范编码 INSERT INTO c_tbf02_ltys (STL_GRD, DAT_TYPE, ROOM1, ROOM2, ROOM3, ROOM4, ROOM5, ROOM6, ROOM7, ROOM8, ROOM9, ROOM10, ROOM11, ROOM12, ROOM13, ROOM14, ROOM15, ROOM16, ROOM17, ROOM18) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) DELETE FROM TBB01_SEQ_PROD WHERE PROD_CD = ?