Usage Truncate Table in PLSQL Blocks You can truncate table in a plsql block with the following code: execute immediate 'truncate table schema.tablename';