Oracle临时表学习

 CREATE GLOBAL TEMPORARY TABLE QCUI_Temp_T_ADDRESS  
 ON COMMIT DELETE ROWS   
 AS   
 SELECT * FROM T_ADDRESS;		--创建临时表（结构和T_ADDRESS一致）

INSERT INTO QCUI_Temp_T_ADDRESS
SELECT * FROM T_ADDRESS;		--往临时表中插入T_ADDRESS的数据


 SELECT * FROM QCUI_Temp_T_ADDRESS;  --查询数据，可以查到数据	
 COMMIT;				     --提交，把临时表的数据删除
 
 SELECT * FROM QCUI_Temp_T_ADDRESS;   --查不到数据