+ 1

what is temp table and what is the use of temptable in SQL

what is temp table?

6th Dec 2016, 3:51 PM
SQL LOVER
SQL LOVER - avatar
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.
6th Dec 2016, 7:58 PM
James Durand
James Durand - avatar
+ 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).
7th Dec 2016, 1:19 PM
Samuel Mayol
Samuel Mayol - avatar