CREATE GLOBAL TEMPORARY TABLE tmp_test as
select * from tb_backorder where 1 = 0insert into tmp_test select * from tb_backorder//显示有数据插入成功
select * from tmp_test//但为什么查询不到数据???
select * from tb_backorder where 1 = 0insert into tmp_test select * from tb_backorder//显示有数据插入成功
select * from tmp_test//但为什么查询不到数据???
select * from tb_backorder;--应是此处没记录
--例:
SQL> drop table tmp_test;已刪除表格.SQL> create global temporary table tmp_test as
2 select * from emp where 1=2;已建立表格.SQL> insert into tmp_test select * from emp;已建立 14 個資料列.SQL> select count(1) from tmp_test; COUNT(1)
----------
14