Syntax options:

    ON COMMIT PRESERVE ROWS | ON COMMIT DELETE ROWS

    Specifies whether data is preserved or deleted after a COMMIT
    statement for global or local temporary tables only.

    The default, if not specified, is ON COMMIT DELETE ROWS.