"You can make more friends in two months by becoming interested in other people, than you will in two years by trying to get other people interested in you."
- Dale Carnegie
Exists only within a query
Materialized by a SELECT Statement inside a query
Space comes from the User’s Spool space
Deleted when the query ends
Created by the User and materialized with an INSERT/SELECT
Space comes from the User’s space
Table and Data are deleted only after a User Logs off the session
The two types of Temporary tables are derived and temporary. You might be asking, "Where are the Global and Local table options for temporary tables"? Global and local temporary ...