是否这样 create or replace procedure(...) as str varchar2(50); begin str:='create table tablea(col_name varchar2(10),...)'; execute immediate str; inset into tablea select ... from tableb where ...; end; /
Begin Create table ……; Execute; Insert Into ……; End;
create or replace procedure(...)
as
str varchar2(50);
begin
str:='create table tablea(col_name varchar2(10),...)';
execute immediate str;
inset into tablea select ... from tableb where ...;
end;
/
Begin
Create table ……;
Execute;
Insert Into ……;
End;