Repository: trafodion Updated Branches: refs/heads/master affc9dbfa -> f38a1006b
[TRAFODION-3172] update documentation for sys_guid function Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/e1e35258 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/e1e35258 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/e1e35258 Branch: refs/heads/master Commit: e1e35258af0c165a4afbbd08c8b98a999c6eb2a3 Parents: b0fe804 Author: LiuMing <ovis_p...@sina.com> Authored: Wed Aug 8 08:01:54 2018 +0800 Committer: LiuMing <ovis_p...@sina.com> Committed: Wed Aug 8 08:01:54 2018 +0800 ---------------------------------------------------------------------- .../sql_functions_and_expressions.adoc | 32 ++++++++++++++++++++ 1 file changed, 32 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/e1e35258/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc index adba842..037b5b1 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc @@ -428,6 +428,7 @@ the expressions have NULL values, the function returns a NULL value. | <<nvl_function,NVL Function>> | Returns the value of the first operand unless it is NULL, in which case it returns the value of the second operand. | <<user_function,USER Function>> | Returns either the database user name of the current user who invoked the function or the database user name associated with the specified user ID number. +| <<sys_guid_function,SYS_GUID Function>> | Returns a globally unique identifier. |=== See the individual entry for the function. @@ -10601,6 +10602,37 @@ DB ROOT ``` <<< +[[sys_guid_function]] +== SYS_GUID Function +SYS_GUID returns a global unique identifier. The identifier is a 16-byte value +tranformed into HEX format. +This function is for Oracle compatiblity. + +``` +SYS_GUID () +``` + +[[data_type_of_the_result]] +==== Data Type of the Result + +The data type of the result is always CHAR(32). + +[[examples_of_sys_guid]] +=== Examples of SYS_GUID + +* Returns a global unique identifier ++ +``` +SELECT SYS_GUID() AS ID FROM dual; + +ID +------------------------- + 5D35B676r5F758E6E0E40F00F0835536 + +--- 1 row(s) selected. +``` + +<<< [[variance_function]] == VARIANCE Function