The CREATE ... TEMPORARY TABLE statement creates a temporary table.

project management training courses malaysia

Specify either GLOBAL TEMPORARY TABLE or PRIVATE TEMPORARY TABLE. In both cases, the ON COMMIT clause specifies whether the table data is transaction-specific (default) or session-specific. You create a temporary table for the database itself, not for every PL/SQL stored procedure.

iot training courses malaysia

You can create indexes for global (not private) temporary tables with the CREATE INDEX statement. These indexes are also temporary. The data in the index has the same session or transaction scope as the data in the temporary table. You can also create a view or trigger on a global temporary table.

itil training courses malaysia

See also

• “Overview of Views”
• “Overview of Triggers”
• Oracle Database Administrator’s Guide to learn how to create and manage temporary tables
• Oracle Database SQL Language Reference for CREATE ... TEMPORARY TABLE syntax and semantics

devops training courses malaysia