임시테이블(GLOBAL TEMPORARY TABLE)

임시 테이블을 구성해서 처리해야되는 경우 힘빼지 말고 이렇게 하지!~

CREATE GLOBAL TEMPORARY TABLE [ON COMMIT DELETE ROWS | ON COMMIT PRESERVE ROWS]
AS
SELECT 1 AS COL1, 'A' AS COL2 FROM DUAL
/

[OPTION]
* ON COMMIT DELETE ROWS : when user exeucte commit process, temporay data is deleted.
* ON COMMIT PRESERVE ROWS : when user disconnect session, temporary data is deleted.