Pl/SQL Truncate Table

You should consider about using Truncate table statement in your Pl/SQL code. Truncate table have better performance but you cannot rollback data after truncate. Truncate table can be executed in combination with EXECUTE IMMEDIATE command in Pl/SQL code.

Example:

DECLARE
BEGIN
      EXECUTE IMMEDIATE 'TRUNCATE TABLE test_table';
.
.
.
END;