如果是记录集合: str:='select * from ||table_name||‘ where id =.....'; open c for str;
create procedure pro(p_tablename in varchar2) as str varchar2(50); begin str:='create table '||p_tablename||' (a varcar2(10))'; --grant create any table to new_user execute immediate str; end; /
open c for str;
as
str varchar2(50);
begin
str:='create table '||p_tablename||' (a varcar2(10))'; --grant create any table to new_user
execute immediate str;
end;
/