EXEC SQL APPEND INTO STS_RUNNINGNUMBER_OBU (PPBZ,ZH,DMH,CDH,XDCDH,XSFX,RSUJYMS,RSUBH,PSAMkH,RSUZDJYLSH,JYSJ,
TXSJSX,TXSJXX,JYZT,KH,OBUZDJYLSH,OBUID,CPH,CPYS,CXDM,CLYHLX,OBUCXBZ,OBUDLXX,OBUJYXX,MYBBH,JYYE,TAC,
SCJYCGTXH,CLSJ) (SELECT '4',ZH,DMH,CDH,XDCDH,XSFX,RSUJYMS,RSUBH,PSAMKH,RSUZDJYLSH,JYSJ,TXSJSX,
TXSJXX,JYZT,KH,OBUZDJYLSH,OBUID,CPH,CPYS,CXDM,CLYHLX,OBUCXBZ,OBUDLXX,OBUJYXX,MYBBH,
JYYE,TAC,SCJYCGTXH,SYSTIMESTAMP FROM STS_RUNNINGNUMBER_OBU_PRE WHERE CLSJ<=TO_DATE(:time1,'yyyy-mm-dd hh24:mi:ss') AND JYCLBZ='0' );
运行时提示:ORA-00900: 无效 SQL 语句
TXSJSX,TXSJXX,JYZT,KH,OBUZDJYLSH,OBUID,CPH,CPYS,CXDM,CLYHLX,OBUCXBZ,OBUDLXX,OBUJYXX,MYBBH,JYYE,TAC,
SCJYCGTXH,CLSJ) (SELECT '4',ZH,DMH,CDH,XDCDH,XSFX,RSUJYMS,RSUBH,PSAMKH,RSUZDJYLSH,JYSJ,TXSJSX,
TXSJXX,JYZT,KH,OBUZDJYLSH,OBUID,CPH,CPYS,CXDM,CLYHLX,OBUCXBZ,OBUDLXX,OBUJYXX,MYBBH,
JYYE,TAC,SCJYCGTXH,SYSTIMESTAMP FROM STS_RUNNINGNUMBER_OBU_PRE WHERE CLSJ<=TO_DATE(:time1,'yyyy-mm-dd hh24:mi:ss') AND JYCLBZ='0' );
运行时提示:ORA-00900: 无效 SQL 语句
你如果是想向数据库插入数据,用insert看看.