Sqlserver

Create table #local_tablename
Create table ##global_tablename

MySQL
Create temporary table tanlename

Oracle
Greate global temporary table tablename

There are lots of temporary table in our enterprise resource planning system.

The advantages and disadvantages of using a temporary table in a database:
Advantages:
Avoid repeated calculations

Disadvantages:
Data loss