For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
how to perform DDL operation using function
create or replace function f1
return number
as
begin
execute and immediate 'truncate table t1';
execute immediate 'grant select on t1 to sys';
end;
/