declare
lvtbl varchar2(1000);
begin
lvtbl := 'create table mytmp(name varchar2(10))';
EXECUTE IMMEDIATE lvtbl;
lvtbl := 'drop table mytmp';
EXECUTE IMMEDIATE lvtbl;
end;
lvtbl varchar2(1000);
begin
lvtbl := 'create table mytmp(name varchar2(10))';
EXECUTE IMMEDIATE lvtbl;
lvtbl := 'drop table mytmp';
EXECUTE IMMEDIATE lvtbl;
end;
as
str varchar2(50);
begin
str:='create table aa(...)';
execute immediate str; --grant create any table to new_user
end;
/