1.第一种，事物级，当 commit以后数据就查不到了。关键字是commit delete rows
CREATE GLOBAL TEMPORARY TABLE
t_temp2 ON COMMIT DELETE ROWS
AS SELECT 1 AS ID FROM dual;
2.第二种，会话级，退出会话以后，数据才查不到关键字comit preserve rows
CREATE GLOBAL TEMPORARY TABLE
t_temp1 ON COMMIT PRESERVE ROWS
AS SELECT 1 AS ID FROM dual;
阅读(1014) | 评论(0) | 转发(0) |
