Oracle Truncate Table

Statement truncate table can be also executed in procedure or function.

Oracle Pl/SQL truncate statement TRUNCATE TABLE will perform better than statement DELETE TABLE, but you must consider that after truncate is not possible to rollback data.

After truncate table statement commit is not needed.


TRUNCATE TABLE table_to_truncate;

TRUNCATE table in procedure or function is described with example Here