操作临时表+事务级别临时表操作+会话级别临时表操作

事务级别临时表操作
举例
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;