在存储过程中调用sql语句

在存储过程中调用sql语句

begin
str:='CREATE GLOBAL TEMPORARY TABLE TABLENAME ON COMMIT PRESERVE ROWS as select * from others_table';
execute immediate str;

[@more@]需要创建一个临时表，请举例说明，谢谢！
delphi_win_sdk ---------------------------------------------------------------

是TEMPORARY
CREATE GLOBAL TEMPORARY TABLE flight_schedule (
startdate DATE,
enddate DATE,
cost NUMBER)

---------------------------------------------------------------

create proecdure name_pro
as
str varchar2(100);
begin
str:='CREATE GLOBAL TEMPORARY TABLE TABLENAME ON COMMIT PRESERVE ROWS as select * from others_table';
execute immediate str;
end;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/620862/viewspace-863575/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/620862/viewspace-863575/