trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lium...@apache.org
Subject [1/2] trafodion git commit: [TRAFODION-3172] update documentation for sys_guid function
Date Thu, 09 Aug 2018 13:02:39 GMT
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_poly@sina.com>
Authored: Wed Aug 8 08:01:54 2018 +0800
Committer: LiuMing <ovis_poly@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
 


Mime
View raw message