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
---------- ----------
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