请教：存储过程的调试执行

Question

http://www.engin.umich.edu/caen/wls/software/oracle/index.htm

Answer 1

SQL> select * from aa;ID                SAL
---------- ----------
1                  20
1                  30
2                  10SQL> begin
  2    execute immediate 'truncate table aa';
  3  end;
  4  /PL/SQL procedure successfully completedSQL> select * from aa;ID                SAL
---------- ----------EXECUTE IMMEDIATE 'TRUNCATE TABLE t2'  --grant drop any table to user