会话结束后,自动关闭。 create procedure gettemp as str varchar2(100); begin str:='CREATE GLOBAL TEMPORARY TABLE TABLENAME ( COL1 VARCHAR2(10), COL2 NUMBER ) ON COMMIT PRESERVE ROWS'; execute immediate str;--grant create any table to user; insert into tablename select * from other_table; end; /
create procedure gettemp
as
str varchar2(100);
begin
str:='CREATE GLOBAL TEMPORARY TABLE TABLENAME (
COL1 VARCHAR2(10),
COL2 NUMBER
) ON COMMIT PRESERVE ROWS';
execute immediate str;--grant create any table to user;
insert into tablename select * from other_table;
end;
/