CREATE GLOBAL TEMPORARY TABLE tablename (column specifications) ON COMMIT (DELETE ROWS | PRESERVE ROWS) CREATE GLOBAL TEMPORARY TABLE PHONE_BILLING (CUSTOMER_ID NUMBER, BILLING_PERIOD VARCHAR2(20), TRANSACTION_DATE DATE, TRANSACTION_TYPE VARCHAR2(10), DURATION NUMBER, CHARGE_AMOUNT NUMBER, TAX_AMOUNT NUMBER) ON COMMIT PRESERVE ROWS;
Location 1 | DELETE ROWS means that the Oracle will truncate the table (all rows are deleted) after each commit. |
Location 2 | PRESERVE ROWS means that Oracle will not truncate the table until the end of the session. |