17,377
社区成员
发帖
与我相关
我的任务
分享
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;