Oracle 事务级的临时表

create global temporary table testtemp(
uuid varchar(20),
name varchar(50)
)ON COMMIT DELETE ROWS;

insert into testtemp values('1','233');

select *from testtemp;

drop table testtemp;

 

posted @ 2017-01-11 20:13  抽象工作室upup  阅读(542)  评论(0编辑  收藏  举报