全局临时表

TBNoO

于 2016-04-15 14:34:44 发布

阅读量402

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle数据库开发

本文链接：https://blog.csdn.net/badyflf/article/details/51161514

Oracle数据库开发专栏收录该内容

48 篇文章

订阅专栏

作用：高效删除，不同会话独立  
--
CREATE GLOBAL TEMPORARY  TABLE t_tmp_session on commit preserve rows 
as
select * from dba_objects where 2 =1 ;



CREATE GLOBAL TEMPORARY  TABLE t_tmp_transction on commit delete rows 
as
select * from dba_objects  where 2 =1 ;


--
insert into  t_tmp_session t 
select * from dba_objects where rownum <=500;

insert into  t_tmp_session t 
select * from dba_objects where rownum <=1200;
 
select count(*) from t_tmp_session;

--  
insert into  t_tmp_transction t 
select * from dba_objects where rownum <=600;

select count(*) from t_tmp_transction t;

 

------不指定 相当于 全局临时事务表
CREATE GLOBAL TEMPORARY  TABLE t_tmp_norm 
as
select * from dba_objects where 2 =1 ;



insert into  t_tmp_norm t 
select * from dba_objects where rownum <=500;
commit; 
select count(*) from t_tmp_norm t;