事务级别临时表操作
举例
create global temporary table student2_transcation(
sno varchar2(10),
sname varchar2(20),
sage number(2),
cno varchar2(2)
)on commit delete rows;
insert into student2_transcation values(‘1’,’lilia’,18,’1’);
select * from student2_transcation;
commit;
select * from student2_transcation;
会话级别临时表操作
举例
create global temporary table student2_session(
sno varchar2(10) ,
sname varchar2(20),
sage number(2),
cno varchar2(2)
)on commit preserve rows;
insert into student2_session values(‘1’,’lilia’,18,’1’);
commit;
select * from student2_session;
exit;
select * from student2_session;