GTT

[PL/SQL] 임시테이블(GTT)

임시테이블 (GTT, Global Temporary Table)1. 트랜잭션 GTT트랜잭션이 살아있는 동안에만 데이터가 유지됨123456CREATE GLOBAL TEMPORARY TABLE 테이블명( 컬럼1 데이터타입, ...)[ON COMMIT DELETE ROWS];cs 1234567CREATE GLOBAL TEMPORARY TABLE CH14_TRANC_GTT( IDS NUMBER , NAMES VARCHAR2(50) , BIRTH_DT DATE)ON COMMIT DELETE ROWS;cs 1234567891011121314151617181920212223DECLARE VN_CNT INT := 0; VN_CNT2 INT := 0;BEGIN INSERT INTO CH14_TRANC_GTT SELECT..