Posts Oracle plsql DDL in procedure
Post
Cancel

Oracle plsql DDL in procedure

  • Running DDL like truncate in procedure
1
2
3
4
5
create or replace procedure proc_truncate_table
is
begin
 execute immediate 'truncate table data_table';
end;
  • calling the above procedure
1
CALL proc_truncate_table ();
This post is licensed under CC BY 4.0 by the author.