需要创建一个临时表，请举例说明，谢谢！
是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;
/
