Database Reference
In-Depth Information
What do all of these object table examples prove? Not much! Personally,
I prefer to avoid using too much pure object-like structure in a relational
database because object and relational structure are completely different in
nature. I prefer to save the object-things for applications or even an object
database.
18.3.3
Creating Temporary Tables
Figure 18.7 shows a syntax diagram containing syntax details for creating
temporary tables.
Figure 18.7
CREATE TABLE
Syntax for a
Temporary Table.
A global temporary table is used to store data temporarily for a specific
session. The GLOBAL keyword dictates that the structure of the table is
available to all sessions but not the rows. Rows created in a temporary table
can be made available, with the ON COMMIT PRESERVE ROWS modi-
fier, for the life of the session that created rows in that temporary table. ON
COMMIT DELETE ROWS is the default and will remove all session-spe-
cific rows from the table on execution of a COMMIT command.
Note:
When two sessions create rows in the same temporary table, each ses-
sion is able to use only the rows it created. The other session's rows are not
available.
