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;