A temporary table (in most RDMS) is a place to keep data for the duration of some application process. The data is basically private and only available to the application user.
The typical end-user of a temporary table ranges from simple ad-hoc dynamic end-users (like you or me) up to real application programs (native SQL stored procedures or COBOL).
Temporary tables are used in dynamic and static SQL.
A temporary table is a place to store relevant to your needs. Whether you are an application or some end-user. It is a place to keep data. It helps give SQL coding options. They can help reduce SQL complexity! You can break down potentially complex, confusing or large SQL into smaller SQL chunks via temporary tables.
Click here to read the full article. (IDUG login required):