create-local-temporary-table
Differences
This shows you the differences between two versions of the page.
|
create-local-temporary-table [2015/09/23 20:27] 127.0.0.1 external edit |
create-local-temporary-table [2016/04/20 07:35] dmtolpeko |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== CREATE LOCAL TEMPORARY TABLE - PL/HQL ====== | + | ====== CREATE LOCAL TEMPORARY TABLE ====== |
| CREATE LOCAL TEMPORARY TABLE statement allows you to create a temporary table for the current session. | CREATE LOCAL TEMPORARY TABLE statement allows you to create a temporary table for the current session. | ||
| Line 17: | Line 17: | ||
| * The local temporary table is automatically dropped at the end of session. | * The local temporary 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 LOCAL TEMPORARY TABLE temp1 | CREATE LOCAL TEMPORARY TABLE temp1 | ||
| Line 39: | Line 39: | ||
| **Compatibility:** ANSI SQL | **Compatibility:** ANSI SQL | ||
| - | **Version**: PL/HQL 0.3.1 | + | **Version**: HPL/SQL 0.3.1 |
| See also: | See also: | ||
Page Tools
