This shows you the differences between two versions of the page.
— |
user [2015/09/23 20:27] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== USER Function - PL/HQL ====== | ||
+ | |||
+ | USER function returns the name of the user executing the current PL/HQL script. | ||
+ | |||
+ | **Syntax**: | ||
+ | |||
+ | <code language="sql"> | ||
+ | USER | ||
+ | </code> | ||
+ | |||
+ | **Return Type:** | ||
+ | |||
+ | STRING | ||
+ | |||
+ | **Example**: | ||
+ | |||
+ | Get the current user: | ||
+ | |||
+ | <code language="sql"> | ||
+ | USER | ||
+ | -- | ||
+ | paul | ||
+ | </code> | ||
+ | |||
+ | **Compatibility**: Oracle, IBM DB2 and Teradata. | ||
+ | |||
+ | **Version:** PL/HQL 0.3.11 | ||
+ | |||
+ | See also: | ||
+ | |||
+ | * [[current-user|CURRENT_USER]] | ||