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; --查不到数据