Syntax options:

    ON COMMIT PRESERVE ROWS | ON COMMIT DELETE ROWS

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

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