A temporary table has a definition and structure like that of a regular table, except that the data only exists for the duration of the current transaction or session. As of Oracle8i, it is possible to create temporary tables “on-the-fly” to hold private session or transaction data. This feature creates the temporary table automatically in the users temporary tablespace.
