How to Apply Truncate Inside Oracle Procedure?

 

you can not directly apply the truncate statement inside the oracle procedure. DDL and Truncate command not allowed directly inside the PL/SQL block. So always keep in mind.

but there is another way to execute these statement even inside the PL/SQL blocks.

use execute immediate statement to execute such kind of statements. for example we have a table called my_sql_table and we want to use truncate state with this table. use the blow statement to use truncate

execute immediate 'TRUNCATE  table GT_RO_exhibrts_appliesto';