当前位置:数据库 > Oracle >>

oracle临时表测试

oracle临时表测试
 
create global temporary table ts(co char(1)) on commit preserve rows;
insert into ts values(1);
select * from ts;
truncate table ts;

create global temporary table tc(co char(1)) on commit delete rows;
insert into tc values(1);
--commit;
select * from tc;

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,