Global Temporary Tables¶
Global temporary tables are converted to local temporary tables.
Input - GLOBAL TEMPORARY TABLE
CREATE GLOBAL TEMPORARY TABLE
"Pack1"."GLOBAL_TEMP_TABLE"
( "ID" VARCHAR2(8)
) ON COMMIT DELETE ROWS ;
Output
CREATE
LOCAL TEMPORARY TABLE
"Pack1_GLOBAL_TEMP_TABLE" (
"ID" VARCHAR2 (8)
)
ON COMMIT PRESERVE ROWS ;