Explicitly declares a local temporary table.

    The metadata for a declared local temporary table is not stored
    in the database and cannot be shared by other modules. These
    tables are sometimes called scratch tables.

    The data stored in the table cannot be shared between SQL
    sessions or modules in a single session. Unlike persistent
    base tables, the metadata and data do not persist beyond an SQL
    session.

    In addition to declared local temporary tables, there are two
    other types of temporary tables:

    o  Global temporary tables

    o  Local temporary tables

    See the CREATE TABLE statement for additional information on
    global and local temporary tables.