O'Reilly logo

Tera-Tom Genius Series - Oracle SQL by Leona Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7 – Temporary Tables

“I cannot imagine any condition which would cause this ship to founder. Modern shipbuilding has gone beyond that.”

- E. I. Smith, Captain of the Titanic

There are two types of Temporary Tables

Derived Table

•Exists only within a query

•Materialized by a SELECT Statement inside a query

•Space comes from the User’s Spool space

•Deleted when the query ends

Global Temporary Table

•Table definition is created by a User and the table definition is permanent

•Materialized with an INSERT/SELECT

•When User logs off the session the data is deleted, but the table definition stays

•Many Users can populate the same Global table, but each has their own copy

•Global temporary tables are created in the public schema, with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required