CREATE GLOBAL TEMPORARY TABLE [模式.]table_name
(
col1 TYPE
col2 TYPE
col3 TYPE
.........
)
ON COMMIT DELETE | PRESERVE ROWS
(
col1 TYPE
col2 TYPE
col3 TYPE
.........
)
ON COMMIT DELETE | PRESERVE ROWS
startdate DATE,
enddate DATE,
cost NUMBER)
ON COMMIT PRESERVE ROWS;
基于会话的临时表,你的会话断开,数据自动清除.