ORA-00911:无效字符蟾蜍 [英] ORA-00911: invalid character Toad

问题描述

我正在使用Toad 11.5

I am using Toad 11.5

当我运行多个truncate语句时，它给出错误 ORA-00911:无效字符

when I run multiple truncate statement, it gives an error ORA-00911: invalid character

truncate table employees;
truncate table employees_edit_history;
truncate table sourcecontributioncalc;

但是当我一一运行时，它执行成功！当我一次运行所有语句时，为什么蟾蜍给出一个错误?

but when I run it one bye one , it execute successfully! Why toad giving an error when I run all statements once?

以及对此的任何解决方案?

and any solution for that ?

推荐答案

将其作为语句(F9)运行时，不能有多个语句，并且分号是无意义的-因为它们是语句分隔符. (例如，在execute immediate或JDBC调用中使用分号时会出现相同的错误，因为它们仅支持单个语句.)

When you run it as a statement (F9) you can't have multiple statements, and the semicolons are meaningless - as they are statement separators. (You get the same error with a semicolon in an execute immediate or JDBC call, for example, as they only support a single statement).

如果您以脚本(F5)运行，则这些分隔符确实具有含义，并且它们分隔的多个语句将按顺序执行.

If you run as a script (F5) instead then those separators do have meaning, and the multiple statements that they, er, separate will be executed in sequence.

这篇关于ORA-00911:无效字符蟾蜍的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！