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:
1 2 3 4 5 6 7 |
DECLARE BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE test_table'; . . . END; |