What is a temp sql table?

Question

Oracle

A friend advised me to use a tempo table in the database. What is it? Where to read the description?

Answer 1

It is possible on the off site
https://docs.oracle.com/cd/B28359_01/server.111/b2...
or in Russian (the first that Google gave out)
www.cyberguru.ru/database/oracle/temp-tables. html

Answer 2

A "tempo" table is a table that exists within a single query (at least it should, if you delete it and consider deleting it in case the query itself fails). It can be used as a regular table - join, select, and so on. I hope this is a fairly correct solution for your task, since in oracle there is also such a thing as a CTE, which is very similar to a temporary table, but does not require its manual removal.