语句
INSERT INTO mytalbe(id,content,SENDTIME,USERID)VALUES(ergps_4_0.SEQUENCE_mytableID.nextval,' dfasfda ','2007-10-23 ',-1 ) ;select SEQUENCE_DICTATESENDID.currval dictatesendID from dual
程序中拼出来的语句,在pl/sql中运行 告诉我两条语句中间的“;”无效符号 INSERT INTO mytalbe(id,content,SENDTIME,USERID)VALUES(ergps_4_0.SEQUENCE_mytableID.nextval,' dfasfda ','2007-10-23 ',-1 ) ;select SEQUENCE_DICTATESENDID.currval dictatesendID from dual
我在插入语句的“;”后面按回车键后,运行成功oracle中运行多条语句时,必须以换行来结束一条语句? oracle语句怎么拼能实现这个换行?
望高手指教,谢谢
INSERT INTO mytalbe(id,content,SENDTIME,USERID)VALUES(ergps_4_0.SEQUENCE_mytableID.nextval,' dfasfda ','2007-10-23 ',-1 ) ;select SEQUENCE_DICTATESENDID.currval dictatesendID from dual
程序中拼出来的语句,在pl/sql中运行 告诉我两条语句中间的“;”无效符号 INSERT INTO mytalbe(id,content,SENDTIME,USERID)VALUES(ergps_4_0.SEQUENCE_mytableID.nextval,' dfasfda ','2007-10-23 ',-1 ) ;select SEQUENCE_DICTATESENDID.currval dictatesendID from dual
我在插入语句的“;”后面按回车键后,运行成功oracle中运行多条语句时,必须以换行来结束一条语句? oracle语句怎么拼能实现这个换行?
望高手指教,谢谢
前面加BEGIN
最后加END然后再试试
@path/文件
运行