Oracle9i allows you to create temporary tables to hold data just for the duration of a session or even a transaction. After the session or the transaction ends, the table is truncated (i.e., the rows are automatically removed). Temporary tables are handy when you are dealing with complex queries or transactions that require transitory row information before inserting or updating a permanent table.
