create-volatile-table
Differences
This shows you the differences between two versions of the page.
|
create-volatile-table [2015/09/23 20:27] 127.0.0.1 external edit |
create-volatile-table [2016/04/20 07:36] (current) dmtolpeko |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== CREATE VOLATILE TABLE Statement - PL/HQL ====== | + | ====== CREATE VOLATILE TABLE Statement ====== |
| CREATE VOLATILE TABLE statement allows you to create a temporary table for the current session. | CREATE VOLATILE TABLE statement allows you to create a temporary table for the current session. | ||
| Line 17: | Line 17: | ||
| * The volatile table is automatically dropped at the end of session. | * The volatile table is automatically dropped at the end of session. | ||
| - | For more details how temporary table support is implemented in PL/HQL, see [[temporary-tables|Native and Managed Temporary Tables]]. | + | For more details how temporary table support is implemented in HPL/SQL, see [[temporary-tables|Native and Managed Temporary Tables]]. |
| **Example**: | **Example**: | ||
| Line 24: | Line 24: | ||
| <code language=sql> | <code language=sql> | ||
| - | SET plhql.temp.tables = managed; | + | SET hplsql.temp.tables = managed; |
| CREATE VOLATILE TABLE temp1 | CREATE VOLATILE TABLE temp1 | ||
| Line 39: | Line 39: | ||
| **Compatibility:** Teradata | **Compatibility:** Teradata | ||
| - | **Version**: PL/HQL 0.3.1 | + | **Version**: HPL/SQL 0.3.1 |
| See also: | See also: | ||
Page Tools
