使用EXECUTE IMMEDIATE语句执行动态SQL的问题:
想使用:
BEGIN
EXECUTE IMMEDIATE ' CREATE TABLE TEST'
||'(AA NUMBER(10),BB NUMBER(10))';
END;
/
结果报错:
ERROR at line 2:
ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following:
:= . ( @ % ;
The symbol ":= was inserted before "IMMEDIATE" to continue.
我用的是805版本,是不是不支持这样的本机动态SQL操作?谢谢!