sqlplus - 在sqlplus中执行立即截断表

Question

为什么 execute immediate 'truncate table trade_economics'; 在 sqlplus 脚本中给出以下错误？

 BEGIN immediate 'truncate table trade_economics'; END;
                    *
    ERROR at line 1:
    ORA-06550: line 1, column 17:
    PLS-00103: Encountered the symbol "truncate table trade_economics" when
    expecting one of the following:
    := . ( @ % ;
    The symbol ":=" was substituted for "truncate table trade_economics" to
    continue.`

Answer 1

您需要在 immediate 之前添加 execute 才能使其正常工作。

类似于:

begin
    execute immediate 'truncate table foo';
end;
/