+ 1
what is temp table and what is the use of temptable in SQL
what is temp table?
2 Answers
+ 1
Temporary tables are just that, tables that are temporary. They can not be relied upon to exist for long and most commonly are used for complex queries as an intermediate holding area or as a way to store data during a migration.
+ 1
Keep this in mind. Temporary tables in Oracle are different to SQL Server. You create it ONCE and only ONCE, not every session. The rows you insert into it are visible only to your session, and are automatically deleted when you end you session ( or end of the transaction, depending on which "ON COMMIT" clause you use).