需要创建一个临时表，请举例说明，谢谢！
是TEMPORARY
CREATEGLOBALTEMPORARYTABLEflight_schedule(
startdateDATE,
enddateDATE,
costNUMBER)
createproecdurename_pro
as
strvarchar2(100);
begin
str:='CREATEGLOBALTEMPORARYTABLETABLENAMEONCOMMITPRESERVEROWSasselect*fromothers_table';
executeimmediatestr;
end;
/
