ORACLE 暫存表

---- ON COMMIT DELETE ROWS
---- ON COMMIT PRESERVE ROWS by session

CREATE GLOBAL TEMPORARY TABLE XXX_BY_SESSION
ON COMMIT PRESERVE ROWS
AS SELECT * FROM XXX WHERE ROWNUM <= 0;

select owner, table_name
from all_tables
where temporary = 'Y';