17,382
社区成员




EXECUTE IMMEDIATE 'CREATE TABLE T_GROUP_TEMP is select * from T_GROUP';
create or replace procedure sp_cr authid current_user
is
begin
EXECUTE IMMEDIATE 'CREATE TABLE T_GROUP_TEMP as select * from T_GROUP';
end;
前提是当前用户有create table 的权限。v_sql:='CREATE TABLE T_GROUP_TEMP is select * from T_GROUP'
EXECUTE IMMEDIATE v_sql;