You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2018/01/18 19:07:34 UTC
[02/27] trafodion-site git commit: Merge [TRAFODION-2909] PR 1399 and
[TRAFODION-2910] PR 1400
http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/fb76ef66/docs/sql_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html
index 04b6734..bba4753 100644
--- a/docs/sql_reference/index.html
+++ b/docs/sql_reference/index.html
@@ -1337,634 +1337,642 @@ table.CodeRay td.code>pre{padding:0}
<li><a href="#code_value_function">7.26. CODE_VALUE Function</a>
<ul class="sectlevel3">
<li><a href="#examples_of_code_value_function">7.26.1. Examples of CODE_VALUE Function</a></li>
-<li><a href="#concat_function">7.26.2. CONCAT Function</a></li>
-<li><a href="#concatenation_operator">7.26.3. Concatenation Operator (||)</a></li>
-<li><a href="#considerations_for_concat">7.26.4. Considerations for CONCAT</a></li>
-<li><a href="#operands">7.26.5. Operands</a></li>
-<li><a href="#sql-parameters">7.26.6. SQL Parameters</a></li>
-<li><a href="#examples_of_concat">7.26.7. Examples of CONCAT</a></li>
</ul>
</li>
-<li><a href="#converttohex_function">7.27. CONVERTTOHEX Function</a>
+<li><a href="#concat_function">7.27. CONCAT Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_converttohex">7.27.1. Considerations for CONVERTTOHEX</a></li>
-<li><a href="#examples_of_converttohex">7.27.2. Examples of CONVERTTOHEX</a></li>
+<li><a href="#concatenation_operator">7.27.1. Concatenation Operator (||)</a></li>
+<li><a href="#considerations_for_concat">7.27.2. Considerations for CONCAT</a></li>
+<li><a href="#examples_of_concat">7.27.3. Examples of CONCAT</a></li>
</ul>
</li>
-<li><a href="#converttimestamp_function">7.28. CONVERTTIMESTAMP Function</a>
+<li><a href="#converttohex_function">7.28. CONVERTTOHEX Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_converttimestamp">7.28.1. Considerations for CONVERTTIMESTAMP</a></li>
-<li><a href="#examples_of_converttimestamp">7.28.2. Examples of CONVERTTIMESTAMP</a></li>
+<li><a href="#considerations_for_converttohex">7.28.1. Considerations for CONVERTTOHEX</a></li>
+<li><a href="#examples_of_converttohex">7.28.2. Examples of CONVERTTOHEX</a></li>
</ul>
</li>
-<li><a href="#cos_function">7.29. COS Function</a>
+<li><a href="#converttimestamp_function">7.29. CONVERTTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_cos">7.29.1. Examples of COS</a></li>
-<li><a href="#cosh_function">7.29.2. COSH Function</a></li>
-<li><a href="#examples_of_cosh">7.29.3. Examples of COSH</a></li>
-<li><a href="#count_function">7.29.4. COUNT Function</a></li>
-<li><a href="#considerations_for_count">7.29.5. Considerations for COUNT</a></li>
-<li><a href="#examples_of_count">7.29.6. Examples of COUNT</a></li>
-<li><a href="#examples_of_crc32">7.29.7. examples of CR32</a></li>
+<li><a href="#considerations_for_converttimestamp">7.29.1. Considerations for CONVERTTIMESTAMP</a></li>
+<li><a href="#examples_of_converttimestamp">7.29.2. Examples of CONVERTTIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#current_function">7.30. CURRENT Function</a>
+<li><a href="#cos_function">7.30. COS Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current">7.30.1. Examples of CURRENT</a></li>
+<li><a href="#examples_of_cos">7.30.1. Examples of COS</a></li>
+<li><a href="#cosh_function">7.30.2. COSH Function</a></li>
+<li><a href="#examples_of_cosh">7.30.3. Examples of COSH</a></li>
+<li><a href="#count_function">7.30.4. COUNT Function</a></li>
+<li><a href="#considerations_for_count">7.30.5. Considerations for COUNT</a></li>
+<li><a href="#examples_of_count">7.30.6. Examples of COUNT</a></li>
+<li><a href="#examples_of_crc32">7.30.7. examples of CR32</a></li>
</ul>
</li>
-<li><a href="#current_date_function">7.31. CURRENT_DATE Function</a>
+<li><a href="#current_function">7.31. CURRENT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current_date">7.31.1. Examples of CURRENT_DATE</a></li>
+<li><a href="#examples_of_current">7.31.1. Examples of CURRENT</a></li>
</ul>
</li>
-<li><a href="#current_time_function">7.32. CURRENT_TIME Function</a>
+<li><a href="#current_date_function">7.32. CURRENT_DATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current_time">7.32.1. Examples of CURRENT_TIME</a></li>
+<li><a href="#examples_of_current_date">7.32.1. Examples of CURRENT_DATE</a></li>
</ul>
</li>
-<li><a href="#current_timestamp_function">7.33. CURRENT_TIMESTAMP Function</a>
+<li><a href="#current_time_function">7.33. CURRENT_TIME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current_timestamp">7.33.1. Examples of CURRENT_TIMESTAMP</a></li>
+<li><a href="#examples_of_current_time">7.33.1. Examples of CURRENT_TIME</a></li>
</ul>
</li>
-<li><a href="#current_user_function">7.34. CURRENT_USER Function</a>
+<li><a href="#current_timestamp_function">7.34. CURRENT_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_current_user">7.34.1. Considerations for CURRENT_USER</a></li>
-<li><a href="#examples_of_current_user">7.34.2. Examples of CURRENT_USER</a></li>
+<li><a href="#examples_of_current_timestamp">7.34.1. Examples of CURRENT_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#date_add_function">7.35. DATE_ADD Function</a>
+<li><a href="#current_user_function">7.35. CURRENT_USER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_add">7.35.1. Examples of DATE_ADD</a></li>
+<li><a href="#considerations_for_current_user">7.35.1. Considerations for CURRENT_USER</a></li>
+<li><a href="#examples_of_current_user">7.35.2. Examples of CURRENT_USER</a></li>
</ul>
</li>
-<li><a href="#date_sub_function">7.36. DATE_SUB Function</a>
+<li><a href="#date_add_function">7.36. DATE_ADD Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_sub">7.36.1. Examples of DATE_SUB</a></li>
+<li><a href="#examples_of_date_add">7.36.1. Examples of DATE_ADD</a></li>
</ul>
</li>
-<li><a href="#dateadd_function">7.37. DATEADD Function</a>
+<li><a href="#date_sub_function">7.37. DATE_SUB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dateadd">7.37.1. Examples of DATEADD</a></li>
+<li><a href="#examples_of_date_sub">7.37.1. Examples of DATE_SUB</a></li>
</ul>
</li>
-<li><a href="#datediff_function">7.38. DATEDIFF Function</a>
+<li><a href="#dateadd_function">7.38. DATEADD Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_description_of_datediff">7.38.1. Syntax Description of DATEDIFF</a></li>
-<li><a href="#considerations_for_datediff">7.38.2. Considerations for DATEDIFF</a></li>
-<li><a href="#examples_of_datediff">7.38.3. Examples of DATEDIFF</a></li>
-<li><a href="#date_difference_in_year">7.38.4. Date Difference in YEAR</a></li>
-<li><a href="#dateformat_function">7.38.5. DATEFORMAT Function</a></li>
-<li><a href="#considerations_for_dateformat">7.38.6. Considerations for DATEFORMAT</a></li>
-<li><a href="#examples_of_dateformat">7.38.7. Examples of DATEFORMAT</a></li>
+<li><a href="#examples_of_dateadd">7.38.1. Examples of DATEADD</a></li>
</ul>
</li>
-<li><a href="#date_part_function_of_an_interval">7.39. DATE_PART Function (of an Interval)</a>
+<li><a href="#datediff_function">7.39. DATEDIFF Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_part">7.39.1. Examples of DATE_PART</a></li>
+<li><a href="#syntax_description_of_datediff">7.39.1. Syntax Description of DATEDIFF</a></li>
+<li><a href="#considerations_for_datediff">7.39.2. Considerations for DATEDIFF</a></li>
+<li><a href="#examples_of_datediff">7.39.3. Examples of DATEDIFF</a></li>
+<li><a href="#date_difference_in_year">7.39.4. Date Difference in YEAR</a></li>
+<li><a href="#dateformat_function">7.39.5. DATEFORMAT Function</a></li>
+<li><a href="#considerations_for_dateformat">7.39.6. Considerations for DATEFORMAT</a></li>
+<li><a href="#examples_of_dateformat">7.39.7. Examples of DATEFORMAT</a></li>
</ul>
</li>
-<li><a href="#date_part_function_of_a_timestamp">7.40. DATE_PART Function (of a Timestamp)</a>
+<li><a href="#date_part_function_of_an_interval">7.40. DATE_PART Function (of an Interval)</a>
<ul class="sectlevel3">
<li><a href="#examples_of_date_part">7.40.1. Examples of DATE_PART</a></li>
</ul>
</li>
-<li><a href="#date_trunc_function">7.41. DATE_TRUNC Function</a>
+<li><a href="#date_part_function_of_a_timestamp">7.41. DATE_PART Function (of a Timestamp)</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_trunc">7.41.1. Examples of DATE_TRUNC</a></li>
+<li><a href="#examples_of_date_part">7.41.1. Examples of DATE_PART</a></li>
</ul>
</li>
-<li><a href="#day_function">7.42. DAY Function</a>
+<li><a href="#date_trunc_function">7.42. DATE_TRUNC Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_day">7.42.1. Examples of Day</a></li>
+<li><a href="#examples_of_date_trunc">7.42.1. Examples of DATE_TRUNC</a></li>
</ul>
</li>
-<li><a href="#dayname_function">7.43. DAYNAME Function</a>
+<li><a href="#day_function">7.43. DAY Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_dayname">7.43.1. Considerations for DAYNAME</a></li>
-<li><a href="#examples_of_dayname">7.43.2. Examples of DAYNAME</a></li>
+<li><a href="#examples_of_day">7.43.1. Examples of Day</a></li>
</ul>
</li>
-<li><a href="#dayofmonth_function">7.44. DAYOFMONTH Function</a>
+<li><a href="#dayname_function">7.44. DAYNAME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofmonth">7.44.1. Examples of DAYOFMONTH</a></li>
+<li><a href="#considerations_for_dayname">7.44.1. Considerations for DAYNAME</a></li>
+<li><a href="#examples_of_dayname">7.44.2. Examples of DAYNAME</a></li>
</ul>
</li>
-<li><a href="#dayofweek_function">7.45. DAYOFWEEK Function</a>
+<li><a href="#dayofmonth_function">7.45. DAYOFMONTH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofweek">7.45.1. Examples of DAYOFWEEK</a></li>
+<li><a href="#examples_of_dayofmonth">7.45.1. Examples of DAYOFMONTH</a></li>
</ul>
</li>
-<li><a href="#dayofyear_function">7.46. DAYOFYEAR Function</a>
+<li><a href="#dayofweek_function">7.46. DAYOFWEEK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofyear">7.46.1. Examples of DAYOFYEAR</a></li>
+<li><a href="#examples_of_dayofweek">7.46.1. Examples of DAYOFWEEK</a></li>
</ul>
</li>
-<li><a href="#Decode_function">7.47. DECODE Function</a>
+<li><a href="#dayofyear_function">7.47. DAYOFYEAR Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_decode">7.47.1. Considerations for DECODE</a></li>
-<li><a href="#_examples_of_decode">7.47.2. Examples of DECODE</a></li>
+<li><a href="#examples_of_dayofyear">7.47.1. Examples of DAYOFYEAR</a></li>
</ul>
</li>
-<li><a href="#degrees_function">7.48. DEGREES Function</a>
+<li><a href="#Decode_function">7.48. DECODE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_degrees">7.48.1. Examples of Degrees</a></li>
+<li><a href="#considerations_for_decode">7.48.1. Considerations for DECODE</a></li>
+<li><a href="#_examples_of_decode">7.48.2. Examples of DECODE</a></li>
</ul>
</li>
-<li><a href="#diff1_function">7.49. DIFF1 Function</a>
+<li><a href="#degrees_function">7.49. DEGREES Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_diff1">7.49.1. Considerations for DIFF1</a></li>
-<li><a href="#examples_of_diff1">7.49.2. Examples of DIFF1</a></li>
+<li><a href="#examples_of_degrees">7.49.1. Examples of Degrees</a></li>
</ul>
</li>
-<li><a href="#diff2_function">7.50. DIFF2 Function</a>
+<li><a href="#diff1_function">7.50. DIFF1 Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_diff2">7.50.1. Considerations for DIFF2</a></li>
-<li><a href="#examples_of_diff2">7.50.2. Examples of DIFF2</a></li>
+<li><a href="#considerations_for_diff1">7.50.1. Considerations for DIFF1</a></li>
+<li><a href="#examples_of_diff1">7.50.2. Examples of DIFF1</a></li>
</ul>
</li>
-<li><a href="#emptyblob_function">7.51. EMPTY_BLOB() Function</a>
+<li><a href="#diff2_function">7.51. DIFF2 Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_descriptions_of_emptyblob_function">7.51.1. Syntax Descriptions of EMPTY_BLOB() Function</a></li>
-<li><a href="#considerations_for_emptyblob_function">7.51.2. Considerations for EMPTY_BLOB() Function</a></li>
-<li><a href="#examples_of_emptyblob_function">7.51.3. Examples of EMPTY_BLOB() Function</a></li>
+<li><a href="#considerations_for_diff2">7.51.1. Considerations for DIFF2</a></li>
+<li><a href="#examples_of_diff2">7.51.2. Examples of DIFF2</a></li>
</ul>
</li>
-<li><a href="#emptyclob_function">7.52. EMPTY_CLOB() Function</a>
+<li><a href="#emptyblob_function">7.52. EMPTY_BLOB() Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_descriptions_of_emptyclob_function">7.52.1. Syntax Descriptions of EMPTY_CLOB() Function</a></li>
-<li><a href="#considerations_for_emptyclob_function">7.52.2. Considerations for EMPTY_CLOB() Function</a></li>
-<li><a href="#examples_of_emptyclob_function">7.52.3. Examples of EMPTY_CLOB() Function</a></li>
+<li><a href="#syntax_descriptions_of_emptyblob_function">7.52.1. Syntax Descriptions of EMPTY_BLOB() Function</a></li>
+<li><a href="#considerations_for_emptyblob_function">7.52.2. Considerations for EMPTY_BLOB() Function</a></li>
+<li><a href="#examples_of_emptyblob_function">7.52.3. Examples of EMPTY_BLOB() Function</a></li>
</ul>
</li>
-<li><a href="#exp_function">7.53. EXP Function</a>
+<li><a href="#emptyclob_function">7.53. EMPTY_CLOB() Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_exp">7.53.1. Examples of EXP</a></li>
+<li><a href="#syntax_descriptions_of_emptyclob_function">7.53.1. Syntax Descriptions of EMPTY_CLOB() Function</a></li>
+<li><a href="#considerations_for_emptyclob_function">7.53.2. Considerations for EMPTY_CLOB() Function</a></li>
+<li><a href="#examples_of_emptyclob_function">7.53.3. Examples of EMPTY_CLOB() Function</a></li>
</ul>
</li>
-<li><a href="#explain_function">7.54. EXPLAIN Function</a>
+<li><a href="#exp_function">7.54. EXP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_explain_function">7.54.1. Considerations for EXPLAIN Function</a></li>
-<li><a href="#examples_of_explain_function">7.54.2. Examples of EXPLAIN Function</a></li>
+<li><a href="#examples_of_exp">7.54.1. Examples of EXP</a></li>
</ul>
</li>
-<li><a href="#externaltolob_function">7.55. EXTERNALTOLOB Function</a>
+<li><a href="#explain_function">7.55. EXPLAIN Function</a>
<ul class="sectlevel3">
-<li><a href="#externaltolob_function_syntax">7.55.1. Syntax Descriptions of EXTERNALTOLOB Function</a></li>
-<li><a href="#externaltolob_function_considerations">7.55.2. Considerations for EXTERNALTOLOB Function</a></li>
-<li><a href="#externaltolob_function_examples">7.55.3. Examples of EXTERNALTOLOB Function</a></li>
+<li><a href="#considerations_for_explain_function">7.55.1. Considerations for EXPLAIN Function</a></li>
+<li><a href="#examples_of_explain_function">7.55.2. Examples of EXPLAIN Function</a></li>
</ul>
</li>
-<li><a href="#extract_function">7.56. EXTRACT Function</a>
+<li><a href="#externaltolob_function">7.56. EXTERNALTOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_extract">7.56.1. Examples of EXTRACT</a></li>
+<li><a href="#externaltolob_function_syntax">7.56.1. Syntax Descriptions of EXTERNALTOLOB Function</a></li>
+<li><a href="#externaltolob_function_considerations">7.56.2. Considerations for EXTERNALTOLOB Function</a></li>
+<li><a href="#externaltolob_function_examples">7.56.3. Examples of EXTERNALTOLOB Function</a></li>
</ul>
</li>
-<li><a href="#filetolob_function">7.57. FILETOLOB Function</a>
+<li><a href="#extract_function">7.57. EXTRACT Function</a>
<ul class="sectlevel3">
-<li><a href="#filetolob_function_syntax">7.57.1. Syntax Descriptions of FILETOLOB Function</a></li>
-<li><a href="#filetolob_function_examples">7.57.2. Examples of FILETOLOB Function</a></li>
+<li><a href="#examples_of_extract">7.57.1. Examples of EXTRACT</a></li>
</ul>
</li>
-<li><a href="#group_concat_function">7.58. GROUP_CONCAT Function</a>
+<li><a href="#filetolob_function">7.58. FILETOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_group_concat">7.58.1. Examples of GROUP_CONCAT</a></li>
+<li><a href="#filetolob_function_syntax">7.58.1. Syntax Descriptions of FILETOLOB Function</a></li>
+<li><a href="#filetolob_function_examples">7.58.2. Examples of FILETOLOB Function</a></li>
</ul>
</li>
-<li><a href="#hour_function">7.59. HOUR Function</a>
+<li><a href="#group_concat_function">7.59. GROUP_CONCAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_hour">7.59.1. Examples of HOUR</a></li>
+<li><a href="#examples_of_group_concat">7.59.1. Examples of GROUP_CONCAT</a></li>
</ul>
</li>
-<li><a href="#insert_function">7.60. INSERT Function</a>
+<li><a href="#hour_function">7.60. HOUR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_insert">7.60.1. Examples of INSERT</a></li>
+<li><a href="#examples_of_hour">7.60.1. Examples of HOUR</a></li>
</ul>
</li>
-<li><a href="#is_ipv4_function">7.61. IS_IPV4 Function</a>
+<li><a href="#insert_function">7.61. INSERT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_is_ipv4">7.61.1. Examples of IS_IPV4</a></li>
+<li><a href="#examples_of_insert">7.61.1. Examples of INSERT</a></li>
</ul>
</li>
-<li><a href="#is_ipv6_function">7.62. IS_IPV6 Function</a>
+<li><a href="#is_ipv4_function">7.62. IS_IPV4 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_is_ipv6">7.62.1. Examples of IS_IPV6</a></li>
+<li><a href="#examples_of_is_ipv4">7.62.1. Examples of IS_IPV4</a></li>
</ul>
</li>
-<li><a href="#inet_aton_function">7.63. INET_ATON Function</a>
+<li><a href="#is_ipv6_function">7.63. IS_IPV6 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_inet_aton">7.63.1. Examples of INET_ATON</a></li>
+<li><a href="#examples_of_is_ipv6">7.63.1. Examples of IS_IPV6</a></li>
</ul>
</li>
-<li><a href="#inet_ntoa_function">7.64. INET_NTOA Function</a>
+<li><a href="#inet_aton_function">7.64. INET_ATON Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_inet_ntoa">7.64.1. Examples of INET_NTOA</a></li>
+<li><a href="#examples_of_inet_aton">7.64.1. Examples of INET_ATON</a></li>
</ul>
</li>
-<li><a href="#isnull_function">7.65. ISNULL Function</a>
+<li><a href="#inet_ntoa_function">7.65. INET_NTOA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_isnull">7.65.1. Examples of ISNULL</a></li>
+<li><a href="#examples_of_inet_ntoa">7.65.1. Examples of INET_NTOA</a></li>
</ul>
</li>
-<li><a href="#juliantimestamp_function">7.66. JULIANTIMESTAMP Function</a>
+<li><a href="#isnull_function">7.66. ISNULL Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_juliantimestamp">7.66.1. Considerations for JULIANTIMESTAMP</a></li>
-<li><a href="#examples_of_juliantimestamp">7.66.2. Examples of JULIANTIMESTAMP</a></li>
+<li><a href="#examples_of_isnull">7.66.1. Examples of ISNULL</a></li>
</ul>
</li>
-<li><a href="#lastnotnull_function">7.67. LASTNOTNULL Function</a>
+<li><a href="#juliantimestamp_function">7.67. JULIANTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_lastnotnull">7.67.1. Examples of LASTNOTNULL</a></li>
+<li><a href="#considerations_for_juliantimestamp">7.67.1. Considerations for JULIANTIMESTAMP</a></li>
+<li><a href="#examples_of_juliantimestamp">7.67.2. Examples of JULIANTIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#lcase_function">7.68. LCASE Function</a>
+<li><a href="#lastnotnull_function">7.68. LASTNOTNULL Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_lcase">7.68.1. Examples of LCASE</a></li>
-<li><a href="#left_function">7.68.2. LEFT Function</a></li>
-<li><a href="#examples_of_left">7.68.3. Examples of LEFT</a></li>
+<li><a href="#examples_of_lastnotnull">7.68.1. Examples of LASTNOTNULL</a></li>
</ul>
</li>
-<li><a href="#locate_function">7.69. LOCATE Function</a>
+<li><a href="#lcase_function">7.69. LCASE Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_locate">7.69.1. Considerations for LOCATE</a></li>
-<li><a href="#examples_of_locate">7.69.2. Examples of LOCATE</a></li>
+<li><a href="#examples_of_lcase">7.69.1. Examples of LCASE</a></li>
+<li><a href="#left_function">7.69.2. LEFT Function</a></li>
+<li><a href="#examples_of_left">7.69.3. Examples of LEFT</a></li>
</ul>
</li>
-<li><a href="#log_function">7.70. LOG Function</a>
+<li><a href="#locate_function">7.70. LOCATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_log">7.70.1. Examples of LOG</a></li>
-<li><a href="#log10_function">7.70.2. LOG10 Function</a></li>
-<li><a href="#examples_of_log10">7.70.3. Examples of LOG10</a></li>
+<li><a href="#considerations_for_locate">7.70.1. Considerations for LOCATE</a></li>
+<li><a href="#examples_of_locate">7.70.2. Examples of LOCATE</a></li>
</ul>
</li>
-<li><a href="#lower_function">7.71. LOWER Function</a>
+<li><a href="#log_function">7.71. LOG Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_lower">7.71.1. Considerations for LOWER</a></li>
-<li><a href="#examples_of_lower">7.71.2. Examples of LOWER</a></li>
-<li><a href="#lpad_function">7.71.3. LPAD Function</a></li>
-<li><a href="#examples_of_lpad">7.71.4. Examples of LPAD</a></li>
+<li><a href="#examples_of_log">7.71.1. Examples of LOG</a></li>
+<li><a href="#log10_function">7.71.2. LOG10 Function</a></li>
+<li><a href="#examples_of_log10">7.71.3. Examples of LOG10</a></li>
</ul>
</li>
-<li><a href="#ltrim_function">7.72. LTRIM Function</a>
+<li><a href="#lower_function">7.72. LOWER Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_ltrim">7.72.1. Considerations for LTRIM</a></li>
-<li><a href="#examples_of_ltrim">7.72.2. Examples of LTRIM</a></li>
+<li><a href="#considerations_for_lower">7.72.1. Considerations for LOWER</a></li>
+<li><a href="#examples_of_lower">7.72.2. Examples of LOWER</a></li>
+<li><a href="#lpad_function">7.72.3. LPAD Function</a></li>
+<li><a href="#examples_of_lpad">7.72.4. Examples of LPAD</a></li>
</ul>
</li>
-<li><a href="#max_function">7.73. MAX/MAXIMUM Function</a>
+<li><a href="#ltrim_function">7.73. LTRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_max">7.73.1. Considerations for MAX/MAXIMUM</a></li>
-<li><a href="#operands_of_the_expression">7.73.2. Operands of the Expression</a></li>
-<li><a href="#examples_of_max">7.73.3. Examples of MAX/MAXIMUM</a></li>
+<li><a href="#considerations_for_ltrim">7.73.1. Considerations for LTRIM</a></li>
+<li><a href="#examples_of_ltrim">7.73.2. Examples of LTRIM</a></li>
</ul>
</li>
-<li><a href="#md5_function">7.74. MD5 Function</a>
+<li><a href="#max_function">7.74. MAX/MAXIMUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_md5">7.74.1. Examples of MD5</a></li>
+<li><a href="#considerations_for_max">7.74.1. Considerations for MAX/MAXIMUM</a></li>
+<li><a href="#operands_of_the_expression">7.74.2. Operands of the Expression</a></li>
+<li><a href="#examples_of_max">7.74.3. Examples of MAX/MAXIMUM</a></li>
</ul>
</li>
-<li><a href="#min_function">7.75. MIN Function</a>
+<li><a href="#md5_function">7.75. MD5 Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_min">7.75.1. Considerations for MIN</a></li>
-<li><a href="#examples_of_min">7.75.2. Examples of MIN</a></li>
+<li><a href="#examples_of_md5">7.75.1. Examples of MD5</a></li>
</ul>
</li>
-<li><a href="#minute_function">7.76. MINUTE Function</a>
+<li><a href="#min_function">7.76. MIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_minute">7.76.1. Examples of minute</a></li>
+<li><a href="#considerations_for_min">7.76.1. Considerations for MIN</a></li>
+<li><a href="#examples_of_min">7.76.2. Examples of MIN</a></li>
</ul>
</li>
-<li><a href="#mod_function">7.77. MOD Function</a>
+<li><a href="#minute_function">7.77. MINUTE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_mod">7.77.1. Examples of MOD</a></li>
+<li><a href="#examples_of_minute">7.77.1. Examples of minute</a></li>
</ul>
</li>
-<li><a href="#month_function">7.78. MONTH Function</a>
+<li><a href="#mod_function">7.78. MOD Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_month">7.78.1. Examples of MONTH</a></li>
+<li><a href="#examples_of_mod">7.78.1. Examples of MOD</a></li>
</ul>
</li>
-<li><a href="#monthname_function">7.79. MONTHNAME Function</a>
+<li><a href="#month_function">7.79. MONTH Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_monthname">7.79.1. Considerations for MONTHNAME</a></li>
-<li><a href="#examples_of_monthname">7.79.2. Examples of MONTHNAME</a></li>
+<li><a href="#examples_of_month">7.79.1. Examples of MONTH</a></li>
</ul>
</li>
-<li><a href="#movingavg_function">7.80. MOVINGAVG Function</a>
+<li><a href="#monthname_function">7.80. MONTHNAME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingavg">7.80.1. Examples of MOVINGAVG</a></li>
+<li><a href="#considerations_for_monthname">7.80.1. Considerations for MONTHNAME</a></li>
+<li><a href="#examples_of_monthname">7.80.2. Examples of MONTHNAME</a></li>
</ul>
</li>
-<li><a href="#movingcount_function">7.81. MOVINGCOUNT Function</a>
+<li><a href="#movingavg_function">7.81. MOVINGAVG Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_movingcount">7.81.1. Considerations for MOVINGCOUNT</a></li>
-<li><a href="#examples_of_movingcount">7.81.2. Examples of MOVINGCOUNT</a></li>
+<li><a href="#examples_of_movingavg">7.81.1. Examples of MOVINGAVG</a></li>
</ul>
</li>
-<li><a href="#movingmax_function">7.82. MOVINGMAX Function</a>
+<li><a href="#movingcount_function">7.82. MOVINGCOUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingmax">7.82.1. Examples of MOVINGMAX</a></li>
+<li><a href="#considerations_for_movingcount">7.82.1. Considerations for MOVINGCOUNT</a></li>
+<li><a href="#examples_of_movingcount">7.82.2. Examples of MOVINGCOUNT</a></li>
</ul>
</li>
-<li><a href="#movingmin_function">7.83. MOVINGMIN Function</a>
+<li><a href="#movingmax_function">7.83. MOVINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingmin">7.83.1. Examples of MOVINGMIN</a></li>
+<li><a href="#examples_of_movingmax">7.83.1. Examples of MOVINGMAX</a></li>
</ul>
</li>
-<li><a href="#movingstddev_function">7.84. MOVINGSTDDEV Function</a>
+<li><a href="#movingmin_function">7.84. MOVINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingstddev">7.84.1. Examples of MOVINGSTDDEV</a></li>
+<li><a href="#examples_of_movingmin">7.84.1. Examples of MOVINGMIN</a></li>
</ul>
</li>
-<li><a href="#movingsum_function">7.85. MOVINGSUM Function</a>
+<li><a href="#movingstddev_function">7.85. MOVINGSTDDEV Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingsum">7.85.1. Examples of MOVINGSUM</a></li>
+<li><a href="#examples_of_movingstddev">7.85.1. Examples of MOVINGSTDDEV</a></li>
</ul>
</li>
-<li><a href="#movingvariance_function">7.86. MOVINGVARIANCE Function</a>
+<li><a href="#movingsum_function">7.86. MOVINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingvariance">7.86.1. Examples of MOVINGVARIANCE</a></li>
-<li><a href="#nullif_function">7.86.2. NULLIF Function</a></li>
-<li><a href="#examples_of_nullif">7.86.3. Examples of NULLIF</a></li>
+<li><a href="#examples_of_movingsum">7.86.1. Examples of MOVINGSUM</a></li>
</ul>
</li>
-<li><a href="#nullifzero_function">7.87. NULLIFZERO Function</a>
+<li><a href="#movingvariance_function">7.87. MOVINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_nullifzero">7.87.1. Examples of NULLIFZERO</a></li>
+<li><a href="#examples_of_movingvariance">7.87.1. Examples of MOVINGVARIANCE</a></li>
+<li><a href="#nullif_function">7.87.2. NULLIF Function</a></li>
+<li><a href="#examples_of_nullif">7.87.3. Examples of NULLIF</a></li>
</ul>
</li>
-<li><a href="#nvl_function">7.88. NVL Function</a>
+<li><a href="#nullifzero_function">7.88. NULLIFZERO Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_nvl">7.88.1. Examples of NVL</a></li>
+<li><a href="#examples_of_nullifzero">7.88.1. Examples of NULLIFZERO</a></li>
</ul>
</li>
-<li><a href="#octet_length_function">7.89. OCTET_LENGTH Function</a>
+<li><a href="#nvl_function">7.89. NVL Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_octet_length">7.89.1. Considerations for OCTET_LENGTH</a></li>
-<li><a href="#offset_function">7.89.2. OFFSET Function</a></li>
-<li><a href="#examples_of_offset">7.89.3. Examples of OFFSET</a></li>
+<li><a href="#examples_of_nvl">7.89.1. Examples of NVL</a></li>
</ul>
</li>
-<li><a href="#pi_function">7.90. PI Function</a>
+<li><a href="#octet_length_function">7.90. OCTET_LENGTH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_pi">7.90.1. Examples of PI</a></li>
+<li><a href="#considerations_for_octet_length">7.90.1. Considerations for OCTET_LENGTH</a></li>
+<li><a href="#offset_function">7.90.2. OFFSET Function</a></li>
+<li><a href="#examples_of_offset">7.90.3. Examples of OFFSET</a></li>
</ul>
</li>
-<li><a href="#position_function">7.91. POSITION Function</a>
+<li><a href="#pi_function">7.91. PI Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_position">7.91.1. Considerations for POSITION</a></li>
-<li><a href="#examples_of_position">7.91.2. Examples of POSITION</a></li>
+<li><a href="#examples_of_pi">7.91.1. Examples of PI</a></li>
</ul>
</li>
-<li><a href="#power_function">7.92. POWER Function</a>
+<li><a href="#position_function">7.92. POSITION Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_power">7.92.1. Examples of POWER</a></li>
+<li><a href="#considerations_for_position">7.92.1. Considerations for POSITION</a></li>
+<li><a href="#examples_of_position">7.92.2. Examples of POSITION</a></li>
</ul>
</li>
-<li><a href="#quarter_function">7.93. QUARTER Function</a>
+<li><a href="#power_function">7.93. POWER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_quarter">7.93.1. Examples of QUARTER</a></li>
+<li><a href="#examples_of_power">7.93.1. Examples of POWER</a></li>
</ul>
</li>
-<li><a href="#radians_function">7.94. RADIANS Function</a>
+<li><a href="#quarter_function">7.94. QUARTER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_radians">7.94.1. Examples of RADIANS</a></li>
+<li><a href="#examples_of_quarter">7.94.1. Examples of QUARTER</a></li>
</ul>
</li>
-<li><a href="#runningrank_function">7.95. RANK/RUNNINGRANK Function</a>
+<li><a href="#radians_function">7.95. RADIANS Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningrank">7.95.1. Considerations for RANK/RUNNINGRANK</a></li>
-<li><a href="#examples_of_runningrank">7.95.2. Examples of RANK/RUNNINGRANK</a></li>
+<li><a href="#examples_of_radians">7.95.1. Examples of RADIANS</a></li>
</ul>
</li>
-<li><a href="#repeat_function">7.96. REPEAT Function</a>
+<li><a href="#runningrank_function">7.96. RANK/RUNNINGRANK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_repeat">7.96.1. Examples of REPEAT</a></li>
+<li><a href="#considerations_for_runningrank">7.96.1. Considerations for RANK/RUNNINGRANK</a></li>
+<li><a href="#examples_of_runningrank">7.96.2. Examples of RANK/RUNNINGRANK</a></li>
</ul>
</li>
-<li><a href="#replace_function">7.97. REPLACE Function</a>
+<li><a href="#repeat_function">7.97. REPEAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_replace">7.97.1. Examples of REPLACE</a></li>
+<li><a href="#examples_of_repeat">7.97.1. Examples of REPEAT</a></li>
</ul>
</li>
-<li><a href="#right_function">7.98. RIGHT Function</a>
+<li><a href="#replace_function">7.98. REPLACE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_right">7.98.1. Examples of RIGHT</a></li>
+<li><a href="#examples_of_replace">7.98.1. Examples of REPLACE</a></li>
</ul>
</li>
-<li><a href="#round_function">7.99. ROUND Function</a>
+<li><a href="#right_function">7.99. RIGHT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_round">7.99.1. Examples of ROUND</a></li>
+<li><a href="#examples_of_right">7.99.1. Examples of RIGHT</a></li>
</ul>
</li>
-<li><a href="#rows_since_function">7.100. ROWS SINCE Function</a>
+<li><a href="#rollup_function">7.100. ROLLUP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rows_since">7.100.1. Considerations for ROWS SINCE</a></li>
-<li><a href="#examples_of_rows_since">7.100.2. Examples of ROWS SINCE</a></li>
+<li><a href="#considerations_for_rollup">7.100.1. Considerations for ROLLUP</a></li>
+<li><a href="#examples_of_rollup">7.100.2. Examples of ROLLUP</a></li>
+<li><a href="#examples_of_null">7.100.3. Examples of NULL</a></li>
</ul>
</li>
-<li><a href="#rows_since_changed_function">7.101. ROWS SINCE CHANGED Function</a>
+<li><a href="#round_function">7.101. ROUND Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rows_since_changed">7.101.1. Considerations for ROWS SINCE CHANGED</a></li>
-<li><a href="#examples_of_rows_since_changed">7.101.2. Examples of ROWS SINCE CHANGED</a></li>
+<li><a href="#examples_of_round">7.101.1. Examples of ROUND</a></li>
</ul>
</li>
-<li><a href="#rpad_function">7.102. RPAD Function</a>
+<li><a href="#rows_since_function">7.102. ROWS SINCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_rpad_function">7.102.1. Examples of RPAD Function</a></li>
+<li><a href="#considerations_for_rows_since">7.102.1. Considerations for ROWS SINCE</a></li>
+<li><a href="#examples_of_rows_since">7.102.2. Examples of ROWS SINCE</a></li>
</ul>
</li>
-<li><a href="#rtrim_function">7.103. RTRIM Function</a>
+<li><a href="#rows_since_changed_function">7.103. ROWS SINCE CHANGED Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rtrim">7.103.1. Considerations for RTRIM</a></li>
-<li><a href="#examples_of_rtrim">7.103.2. Examples of RTRIM</a></li>
+<li><a href="#considerations_for_rows_since_changed">7.103.1. Considerations for ROWS SINCE CHANGED</a></li>
+<li><a href="#examples_of_rows_since_changed">7.103.2. Examples of ROWS SINCE CHANGED</a></li>
</ul>
</li>
-<li><a href="#runningavg_function">7.104. RUNNINGAVG Function</a>
+<li><a href="#rpad_function">7.104. RPAD Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningavg">7.104.1. Considerations for RUNNINGAVG</a></li>
-<li><a href="#examples_of_runningavg">7.104.2. Examples of RUNNINGAVG</a></li>
+<li><a href="#examples_of_rpad_function">7.104.1. Examples of RPAD Function</a></li>
</ul>
</li>
-<li><a href="#runningcount_function">7.105. RUNNINGCOUNT Function</a>
+<li><a href="#rtrim_function">7.105. RTRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningcount">7.105.1. Considerations for RUNNINGCOUNT</a></li>
-<li><a href="#examples_of_runningcount">7.105.2. Examples of RUNNINGCOUNT</a></li>
+<li><a href="#considerations_for_rtrim">7.105.1. Considerations for RTRIM</a></li>
+<li><a href="#examples_of_rtrim">7.105.2. Examples of RTRIM</a></li>
</ul>
</li>
-<li><a href="#runningmax_function">7.106. RUNNINGMAX Function</a>
+<li><a href="#runningavg_function">7.106. RUNNINGAVG Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmax">7.106.1. Examples of RUNNINGMAX</a></li>
+<li><a href="#considerations_for_runningavg">7.106.1. Considerations for RUNNINGAVG</a></li>
+<li><a href="#examples_of_runningavg">7.106.2. Examples of RUNNINGAVG</a></li>
</ul>
</li>
-<li><a href="#runningmin_function">7.107. RUNNINGMIN Function</a>
+<li><a href="#runningcount_function">7.107. RUNNINGCOUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmin">7.107.1. Examples of RUNNINGMIN</a></li>
-<li><a href="#runningstddev_function">7.107.2. RUNNINGSTDDEV Function</a></li>
-<li><a href="#considerations_for_runningstddev">7.107.3. Considerations for RUNNINGSTDDEV</a></li>
-<li><a href="#examples_of_runningstddev">7.107.4. Examples of RUNNINGSTDDEV</a></li>
+<li><a href="#considerations_for_runningcount">7.107.1. Considerations for RUNNINGCOUNT</a></li>
+<li><a href="#examples_of_runningcount">7.107.2. Examples of RUNNINGCOUNT</a></li>
</ul>
</li>
-<li><a href="#runningsum_function">7.108. RUNNINGSUM Function</a>
+<li><a href="#runningmax_function">7.108. RUNNINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningsum">7.108.1. Examples of RUNNINGSUM</a></li>
+<li><a href="#examples_of_runningmax">7.108.1. Examples of RUNNINGMAX</a></li>
</ul>
</li>
-<li><a href="#runningvariance_function">7.109. RUNNINGVARIANCE Function</a>
+<li><a href="#runningmin_function">7.109. RUNNINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningvariance">7.109.1. Examples of RUNNINGVARIANCE</a></li>
+<li><a href="#examples_of_runningmin">7.109.1. Examples of RUNNINGMIN</a></li>
+<li><a href="#runningstddev_function">7.109.2. RUNNINGSTDDEV Function</a></li>
+<li><a href="#considerations_for_runningstddev">7.109.3. Considerations for RUNNINGSTDDEV</a></li>
+<li><a href="#examples_of_runningstddev">7.109.4. Examples of RUNNINGSTDDEV</a></li>
</ul>
</li>
-<li><a href="#second_function">7.110. SECOND Function</a>
+<li><a href="#runningsum_function">7.110. RUNNINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_second">7.110.1. Examples of SECOND</a></li>
+<li><a href="#examples_of_runningsum">7.110.1. Examples of RUNNINGSUM</a></li>
</ul>
</li>
-<li><a href="#sha_function">7.111. SHA Function</a>
+<li><a href="#runningvariance_function">7.111. RUNNINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha">7.111.1. examples of SHA</a></li>
+<li><a href="#examples_of_runningvariance">7.111.1. Examples of RUNNINGVARIANCE</a></li>
</ul>
</li>
-<li><a href="#sha2_function">7.112. SHA2 Function</a>
+<li><a href="#second_function">7.112. SECOND Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha2">7.112.1. examples of SHA2</a></li>
+<li><a href="#examples_of_second">7.112.1. Examples of SECOND</a></li>
</ul>
</li>
-<li><a href="#sign_function">7.113. SIGN Function</a>
+<li><a href="#sha_function">7.113. SHA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sign">7.113.1. Examples of SIGN</a></li>
+<li><a href="#examples_of_sha">7.113.1. examples of SHA</a></li>
</ul>
</li>
-<li><a href="#sin_function">7.114. SIN Function</a>
+<li><a href="#sha2_function">7.114. SHA2 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sin">7.114.1. Examples of SIN</a></li>
+<li><a href="#examples_of_sha2">7.114.1. examples of SHA2</a></li>
</ul>
</li>
-<li><a href="#sinh_function">7.115. SINH Function</a>
+<li><a href="#sign_function">7.115. SIGN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sinh">7.115.1. Examples of SINH</a></li>
-<li><a href="#space_function">7.115.2. SPACE Function</a></li>
-<li><a href="#examples_of_space">7.115.3. Examples of SPACE</a></li>
+<li><a href="#examples_of_sign">7.115.1. Examples of SIGN</a></li>
</ul>
</li>
-<li><a href="#sqrt_function">7.116. SQRT Function</a>
+<li><a href="#sin_function">7.116. SIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sqrt">7.116.1. Examples of SQRT</a></li>
+<li><a href="#examples_of_sin">7.116.1. Examples of SIN</a></li>
</ul>
</li>
-<li><a href="#stddev_function">7.117. STDDEV Function</a>
+<li><a href="#sinh_function">7.117. SINH Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_stddev">7.117.1. Considerations for STDDEV</a></li>
-<li><a href="#examples_of_stddev">7.117.2. Examples of STDDEV</a></li>
+<li><a href="#examples_of_sinh">7.117.1. Examples of SINH</a></li>
+<li><a href="#space_function">7.117.2. SPACE Function</a></li>
+<li><a href="#examples_of_space">7.117.3. Examples of SPACE</a></li>
</ul>
</li>
-<li><a href="#stringtolob_function">7.118. STRINGTOLOB Function</a>
+<li><a href="#sqrt_function">7.118. SQRT Function</a>
<ul class="sectlevel3">
-<li><a href="#stringtolob_function_syntax">7.118.1. Syntax Descriptions of STRINGTOLOB Function</a></li>
-<li><a href="#stringtolob_function_examples">7.118.2. Examples of STRINGTOLOB Function</a></li>
+<li><a href="#examples_of_sqrt">7.118.1. Examples of SQRT</a></li>
</ul>
</li>
-<li><a href="#substring_function">7.119. SUBSTRING/SUBSTR Function</a>
+<li><a href="#stddev_function">7.119. STDDEV Function</a>
<ul class="sectlevel3">
-<li><a href="#alternative_forms">7.119.1. Alternative Forms</a></li>
-<li><a href="#considerations_for_substring">7.119.2. Considerations for SUBSTRING/SUBSTR</a></li>
-<li><a href="#examples_of_substring">7.119.3. Examples of SUBSTRING/SUBSTR</a></li>
+<li><a href="#considerations_for_stddev">7.119.1. Considerations for STDDEV</a></li>
+<li><a href="#examples_of_stddev">7.119.2. Examples of STDDEV</a></li>
</ul>
</li>
-<li><a href="#sum_function">7.120. SUM Function</a>
+<li><a href="#stringtolob_function">7.120. STRINGTOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_sum">7.120.1. Considerations for SUM</a></li>
-<li><a href="#examples_of_sum">7.120.2. Examples of SUM</a></li>
+<li><a href="#stringtolob_function_syntax">7.120.1. Syntax Descriptions of STRINGTOLOB Function</a></li>
+<li><a href="#stringtolob_function_examples">7.120.2. Examples of STRINGTOLOB Function</a></li>
</ul>
</li>
-<li><a href="#tan_function">7.121. TAN Function</a>
+<li><a href="#substring_function">7.121. SUBSTRING/SUBSTR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_tan">7.121.1. Examples of TAN</a></li>
-<li><a href="#tanh_function">7.121.2. TANH Function</a></li>
-<li><a href="#examples_of_tanh">7.121.3. Examples of TANH</a></li>
+<li><a href="#alternative_forms">7.121.1. Alternative Forms</a></li>
+<li><a href="#considerations_for_substring">7.121.2. Considerations for SUBSTRING/SUBSTR</a></li>
+<li><a href="#examples_of_substring">7.121.3. Examples of SUBSTRING/SUBSTR</a></li>
</ul>
</li>
-<li><a href="#this_function">7.122. THIS Function</a>
+<li><a href="#sum_function">7.122. SUM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_this">7.122.1. Considerations for THIS</a></li>
-<li><a href="#examples_of_this">7.122.2. Examples of THIS</a></li>
+<li><a href="#considerations_for_sum">7.122.1. Considerations for SUM</a></li>
+<li><a href="#examples_of_sum">7.122.2. Examples of SUM</a></li>
</ul>
</li>
-<li><a href="#timestampadd_function">7.123. TIMESTAMPADD Function</a>
+<li><a href="#tan_function">7.123. TAN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampadd">7.123.1. Examples of TIMESTAMPADD</a></li>
+<li><a href="#examples_of_tan">7.123.1. Examples of TAN</a></li>
+<li><a href="#tanh_function">7.123.2. TANH Function</a></li>
+<li><a href="#examples_of_tanh">7.123.3. Examples of TANH</a></li>
</ul>
</li>
-<li><a href="#timestampdiff_function">7.124. TIMESTAMPDIFF Function</a>
+<li><a href="#this_function">7.124. THIS Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampdiff">7.124.1. Examples of TIMESTAMPDIFF</a></li>
+<li><a href="#considerations_for_this">7.124.1. Considerations for THIS</a></li>
+<li><a href="#examples_of_this">7.124.2. Examples of THIS</a></li>
</ul>
</li>
-<li><a href="#to_char_function">7.125. TO_CHAR Function</a>
+<li><a href="#timestampadd_function">7.125. TIMESTAMPADD Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_char">7.125.1. Considerations for TO_CHAR</a></li>
-<li><a href="#examples_of_to_char">7.125.2. Examples of TO_CHAR</a></li>
+<li><a href="#examples_of_timestampadd">7.125.1. Examples of TIMESTAMPADD</a></li>
</ul>
</li>
-<li><a href="#to_date_function">7.126. TO_DATE Function</a>
+<li><a href="#timestampdiff_function">7.126. TIMESTAMPDIFF Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_date">7.126.1. Considerations for TO_DATE</a></li>
-<li><a href="#examples_of_to_date">7.126.2. Examples of TO_DATE</a></li>
+<li><a href="#examples_of_timestampdiff">7.126.1. Examples of TIMESTAMPDIFF</a></li>
</ul>
</li>
-<li><a href="#to_time_function">7.127. TO_TIME Function</a>
+<li><a href="#to_char_function">7.127. TO_CHAR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_time">7.127.1. Examples of TO_TIME</a></li>
+<li><a href="#considerations_for_to_char">7.127.1. Considerations for TO_CHAR</a></li>
+<li><a href="#examples_of_to_char">7.127.2. Examples of TO_CHAR</a></li>
</ul>
</li>
-<li><a href="#to_timestamp_function">7.128. TO_TIMESTAMP Function</a>
+<li><a href="#to_date_function">7.128. TO_DATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_timestamp">7.128.1. Example of TO_TIMESTAMP</a></li>
+<li><a href="#considerations_for_to_date">7.128.1. Considerations for TO_DATE</a></li>
+<li><a href="#examples_of_to_date">7.128.2. Examples of TO_DATE</a></li>
</ul>
</li>
-<li><a href="#translate_function">7.129. TRANSLATE Function</a></li>
-<li><a href="#trim_function">7.130. TRIM Function</a>
+<li><a href="#to_time_function">7.129. TO_TIME Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_trim">7.130.1. Considerations for TRIM</a></li>
-<li><a href="#examples_of_trim">7.130.2. Examples of TRIM</a></li>
+<li><a href="#examples_of_to_time">7.129.1. Examples of TO_TIME</a></li>
</ul>
</li>
-<li><a href="#ucase_function">7.131. UCASE Function</a>
+<li><a href="#to_timestamp_function">7.130. TO_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_ucase">7.131.1. Considerations for UCASE</a></li>
-<li><a href="#examples_of_ucase">7.131.2. Examples of UCASE</a></li>
-<li><a href="#upper_function">7.131.3. UPPER Function</a></li>
-<li><a href="#examples_of_upper">7.131.4. Examples of UPPER</a></li>
-<li><a href="#upshift_function">7.131.5. UPSHIFT Function</a></li>
-<li><a href="#examples_of_upshift">7.131.6. Examples of UPSHIFT</a></li>
+<li><a href="#examples_of_to_timestamp">7.130.1. Example of TO_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#user_function">7.132. USER Function</a>
+<li><a href="#translate_function">7.131. TRANSLATE Function</a></li>
+<li><a href="#trim_function">7.132. TRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_user">7.132.1. Considerations for USER</a></li>
-<li><a href="#examples_of_user">7.132.2. Examples of USER</a></li>
+<li><a href="#considerations_for_trim">7.132.1. Considerations for TRIM</a></li>
+<li><a href="#examples_of_trim">7.132.2. Examples of TRIM</a></li>
</ul>
</li>
-<li><a href="#variance_function">7.133. VARIANCE Function</a>
+<li><a href="#ucase_function">7.133. UCASE Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_variance">7.133.1. Considerations for VARIANCE</a></li>
-<li><a href="#examples_of_variance">7.133.2. Examples of VARIANCE</a></li>
+<li><a href="#considerations_for_ucase">7.133.1. Considerations for UCASE</a></li>
+<li><a href="#examples_of_ucase">7.133.2. Examples of UCASE</a></li>
+<li><a href="#upper_function">7.133.3. UPPER Function</a></li>
+<li><a href="#examples_of_upper">7.133.4. Examples of UPPER</a></li>
+<li><a href="#upshift_function">7.133.5. UPSHIFT Function</a></li>
+<li><a href="#examples_of_upshift">7.133.6. Examples of UPSHIFT</a></li>
</ul>
</li>
-<li><a href="#week_function">7.134. WEEK Function</a>
+<li><a href="#user_function">7.134. USER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_week">7.134.1. Examples of WEEK</a></li>
+<li><a href="#considerations_for_user">7.134.1. Considerations for USER</a></li>
+<li><a href="#examples_of_user">7.134.2. Examples of USER</a></li>
</ul>
</li>
-<li><a href="#year_function">7.135. YEAR Function</a>
+<li><a href="#variance_function">7.135. VARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_year">7.135.1. Examples of YEAR</a></li>
+<li><a href="#considerations_for_variance">7.135.1. Considerations for VARIANCE</a></li>
+<li><a href="#examples_of_variance">7.135.2. Examples of VARIANCE</a></li>
</ul>
</li>
-<li><a href="#zeroifnull_function">7.136. ZEROIFNULL Function</a>
+<li><a href="#week_function">7.136. WEEK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_zeroifnull">7.136.1. Examples of ZEROIFNULL</a></li>
+<li><a href="#examples_of_week">7.136.1. Examples of WEEK</a></li>
+</ul>
+</li>
+<li><a href="#year_function">7.137. YEAR Function</a>
+<ul class="sectlevel3">
+<li><a href="#examples_of_year">7.137.1. Examples of YEAR</a></li>
+</ul>
+</li>
+<li><a href="#zeroifnull_function">7.138. ZEROIFNULL Function</a>
+<ul class="sectlevel3">
+<li><a href="#examples_of_zeroifnull">7.138.1. Examples of ZEROIFNULL</a></li>
</ul>
</li>
</ul>
@@ -18592,7 +18600,7 @@ Task: COMPLETION Status: Ended Time: 2018-01-03 16:23:04.301579
Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.381
--- SQL operation complete.
-SQL>select * from target_table1;
+SQL>SELECT * FROM target_table1;
A B
----------- ----
4 dd
@@ -18646,10 +18654,9 @@ drwxr-xr-x - trafodion trafodion 0 2018-01-03 17:19
<div class="paragraph">
<p>Suppose that we have two same tables (<em>source_table</em> and <em>target_table1</em>) as shown in the <a href="#continue_on_error_examples">Examples of <code>CONTINUE ON ERROR</code></a>.</p>
</div>
-<div class="ulist">
-<ul>
-<li>
+<div class="paragraph">
<p>The examples below illustrate how the LOAD Statement behaves depending on the different <code>num</code>.</p>
+</div>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SQL>LOAD WITH STOP AFTER 2 ERROR ROWS INTO target_table1 SELECT * FROM source_table;
@@ -18699,9 +18706,6 @@ A B
--- 3 row(s) selected.</code></pre>
</div>
</div>
-</li>
-</ul>
-</div>
</div>
<div class="sect4">
<h5 id="index_table_only_examples">Examples of <code>INDEX TABLE ONLY</code></h5>
@@ -18761,10 +18765,10 @@ CREATE TABLE TRAFODION.SEABASE.TARGET_TABLE1
</div>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">SQL>select * from target_table2;
+<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT * FROM target_table2;
--- 0 row(s) selected.
-SQL>showddl target_table2;
+SQL>SHOWDDL target_table2;
CREATE TABLE TRAFODION.SEABASE.TARGET_TABLE2
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
@@ -18838,10 +18842,10 @@ SQL>SET PARSERFLAGS 1;
SQL>LOAD WITH INDEX TABLE ONLY INTO TABLE(INDEX_TABLE index_target_table1) SELECT b,a FROM source_table;
--- SQL operation complete.
-SQL>select * from target_table1;
+SQL>SELECT * FROM target_table1;
--- 0 row(s) selected.
-select * from table(index_table index_target_table1);
+SELECT * FROM table(index_table index_target_table1);
B@ A
---- --------------------
aaaa 1
@@ -18878,7 +18882,7 @@ A B
6 fff
--- 6 row(s) selected.
-SQL>select * from table(index_table index_target_table1);
+SQL>SELECT * FROM table(index_table index_target_table1);
B@ A
---- --------------------
aaaa 1
@@ -18982,7 +18986,7 @@ A@
<p>The <em>target_table4</em> has columns A (index column) and B defined, in this case, populate the index table with column A and syskey from the <em>source_table</em>.</p>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">SQL> create index index_target_table4 on target_table4(a) no populate;
+<pre class="CodeRay highlight"><code data-lang="text">SQL> CREATE INDEX index_target_table4 ON target_table4(a) NO POPULATE;
--- SQL operation complete.
SQL>SET PARSERFLAGS 1;
@@ -19048,6 +19052,9 @@ SQL> DROP INDEX index_target_table4;
--- SQL operation complete.</code></pre>
</div>
</div>
+</div>
+<div class="sect4">
+<h5 id="loading_data_from_hive_table_examples">Examples of Loading data from Hive Table</h5>
<div class="ulist">
<ul>
<li>
@@ -31295,8 +31302,9 @@ sets.</p>
</div>
<div style="page-break-after: always;"></div>
</div>
-<div class="sect3">
-<h4 id="concat_function">7.26.2. CONCAT Function</h4>
+</div>
+<div class="sect2">
+<h3 id="concat_function">7.27. CONCAT Function</h3>
<div class="paragraph">
<p>The CONCAT function returns the concatenation of two character value
expressions as a character string value. You can also use the
@@ -31327,9 +31335,8 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p>
</li>
</ul>
</div>
-</div>
<div class="sect3">
-<h4 id="concatenation_operator">7.26.3. Concatenation Operator (||)</h4>
+<h4 id="concatenation_operator">7.27.1. Concatenation Operator (||)</h4>
<div class="paragraph">
<p>The concatenation operator, denoted by two vertical bars (||),
concatenates two string values to form a new string value. To indicate
@@ -31346,11 +31353,9 @@ bars (\|\|):</p>
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_concat">7.26.4. Considerations for CONCAT</h4>
-
-</div>
-<div class="sect3">
-<h4 id="operands">7.26.5. Operands</h4>
+<h4 id="considerations_for_concat">7.27.2. Considerations for CONCAT</h4>
+<div class="sect4">
+<h5 id="operands">Operands</h5>
<div class="paragraph">
<p>A string value can be specified by any character value expression, such
as a character string literal, character string function, column
@@ -31362,8 +31367,8 @@ expression. The value of the operand must be of type CHAR or VARCHAR.</p>
VARCHAR.</p>
</div>
</div>
-<div class="sect3">
-<h4 id="sql-parameters">7.26.6. SQL Parameters</h4>
+<div class="sect4">
+<h5 id="sql-parameters">SQL Parameters</h5>
<div class="paragraph">
<p>You can concatenate an SQL parameter and a character value expression.
The concatenated parameter takes on the data type attributes of the
@@ -31391,8 +31396,9 @@ on the parameter as:</p>
concatenation is 5 March 2002.</p>
</div>
</div>
+</div>
<div class="sect3">
-<h4 id="examples_of_concat">7.26.7. Examples of CONCAT</h4>
+<h4 id="examples_of_concat">7.27.3. Examples of CONCAT</h4>
<div class="ulist">
<ul>
<li>
@@ -31420,7 +31426,7 @@ VALUES (002, 'Executed at ' || CAST (CURRENT_TIMESTAMP AS CHAR(26)));</code></pr
</div>
</div>
<div class="sect2">
-<h3 id="converttohex_function">7.27. CONVERTTOHEX Function</h3>
+<h3 id="converttohex_function">7.28. CONVERTTOHEX Function</h3>
<div class="paragraph">
<p>The CONVERTTOHEX function converts the specified value expression to
hexadecimal for display purposes.</p>
@@ -31447,7 +31453,7 @@ that are not supported by the client terminal’s locale or may be control
codes or other non-displayable characters.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_converttohex">7.27.1. Considerations for CONVERTTOHEX</h4>
+<h4 id="considerations_for_converttohex">7.28.1. Considerations for CONVERTTOHEX</h4>
<div class="paragraph">
<p>Although CONVERTTOHEX is usable on datetime and interval expressions,
the displayed output shows the internal value and is, consequently, not
@@ -31460,7 +31466,7 @@ future releases.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="examples_of_converttohex">7.27.2. Examples of CONVERTTOHEX</h4>
+<h4 id="examples_of_converttohex">7.28.2. Examples of CONVERTTOHEX</h4>
<div class="ulist">
<ul>
<li>
@@ -31543,7 +31549,7 @@ SELECT CONVERTTOHEX(IV1), CONVERTTOHEX(IV2), CONVERTTOHEX(IV3) from IVT;
</div>
</div>
<div class="sect2">
-<h3 id="converttimestamp_function">7.28. CONVERTTIMESTAMP Function</h3>
+<h3 id="converttimestamp_function">7.29. CONVERTTIMESTAMP Function</h3>
<div class="paragraph">
<p>The CONVERTTIMESTAMP function converts a Julian timestamp to a value
with data type TIMESTAMP.</p>
@@ -31568,7 +31574,7 @@ LARGEINT value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_converttimestamp">7.28.1. Considerations for CONVERTTIMESTAMP</h4>
+<h4 id="considerations_for_converttimestamp">7.29.1. Considerations for CONVERTTIMESTAMP</h4>
<div class="paragraph">
<p>The <em>julian-timestamp</em> value must be in the range from 148731
63200000000 to 274927348799999999.</p>
@@ -31594,7 +31600,7 @@ database and display these column values in a TIMESTAMP format.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_converttimestamp">7.28.2. Examples of CONVERTTIMESTAMP</h4>
+<h4 id="examples_of_converttimestamp">7.29.2. Examples of CONVERTTIMESTAMP</h4>
<div class="ulist">
<ul>
<li>
@@ -31627,7 +31633,7 @@ is the same value, 2008-04-03 21:05:36.143000.</p>
</div>
</div>
<div class="sect2">
-<h3 id="cos_function">7.29. COS Function</h3>
+<h3 id="cos_function">7.30. COS Function</h3>
<div class="paragraph">
<p>The COS function returns the cosine of a numeric value expression, where
the expression is an angle expressed in radians.</p>
@@ -31655,7 +31661,7 @@ argument of the COS function.</p>
<p>See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_cos">7.29.1. Examples of COS</h4>
+<h4 id="examples_of_cos">7.30.1. Examples of COS</h4>
<div class="ulist">
<ul>
<li>
@@ -31672,7 +31678,7 @@ approximately 0.9397, the cosine of 0.3491 (which is 20 degrees):</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="cosh_function">7.29.2. COSH Function</h4>
+<h4 id="cosh_function">7.30.2. COSH Function</h4>
<div class="paragraph">
<p>The COSH function returns the hyperbolic cosine of a numeric value
expression, where the expression is an angle expressed in radians.</p>
@@ -31699,7 +31705,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_cosh">7.29.3. Examples of COSH</h4>
+<h4 id="examples_of_cosh">7.30.3. Examples of COSH</h4>
<div class="ulist">
<ul>
<li>
@@ -31716,7 +31722,7 @@ approximately 1.8884, the hyperbolic cosine of 1.25 in radians:</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="count_function">7.29.4. COUNT Function</h4>
+<h4 id="count_function">7.30.4. COUNT Function</h4>
<div class="paragraph">
<p>The COUNT function counts the number of rows that result from a query or
the number of rows that contain a distinct value in a specific column.
@@ -31762,7 +31768,7 @@ values from the one-column table derived from the evaluation of
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_count">7.29.5. Considerations for COUNT</h4>
+<h4 id="considerations_for_count">7.30.5. Considerations for COUNT</h4>
<div class="sect4">
<h5 id="operands-of-the-expression-1">Operands of the Expression</h5>
<div class="paragraph">
@@ -31794,7 +31800,7 @@ COUNT(\*) returns the number of rows in the table.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_count">7.29.6. Examples of COUNT</h4>
+<h4 id="examples_of_count">7.30.6. Examples of COUNT</h4>
<div class="ulist">
<ul>
<li>
@@ -31887,7 +31893,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_crc32">7.29.7. examples of CR32</h4>
+<h4 id="examples_of_crc32">7.30.7. examples of CR32</h4>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">>>SELECT CRC32('Trafodion') from dual;
@@ -31909,7 +31915,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="current_function">7.30. CURRENT Function</h3>
+<h3 id="current_function">7.31. CURRENT Function</h3>
<div class="paragraph">
<p>The CURRENT function returns a value of type TIMESTAMP based on the
current local date and time.</p>
@@ -31945,7 +31951,7 @@ not a string value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_current">7.30.1. Examples of CURRENT</h4>
+<h4 id="examples_of_current">7.31.1. Examples of CURRENT</h4>
<div class="ulist">
<ul>
<li>
@@ -31964,7 +31970,7 @@ SET ship_timestamp = CURRENT WHERE projcode = 1000;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="current_date_function">7.31. CURRENT_DATE Function</h3>
+<h3 id="current_date_function">7.32. CURRENT_DATE Function</h3>
<div class="paragraph">
<p>The CURRENT_DATE function returns the local current date as a value of
type DATE.</p>
@@ -31983,7 +31989,7 @@ not reevaluated (even if it is a long running query).</p>
The value returned is a value of type DATE, not a string value.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_current_date">7.31.1. Examples of CURRENT_DATE</h4>
+<h4 id="examples_of_current_date">7.32.1. Examples of CURRENT_DATE</h4>
<div class="ulist">
<ul>
<li>
@@ -32022,7 +32028,7 @@ THE WORKS 2008-02-02
</div>
</div>
<div class="sect2">
-<h3 id="current_time_function">7.32. CURRENT_TIME Function</h3>
+<h3 id="current_time_function">7.33. CURRENT_TIME Function</h3>
<div class="paragraph">
<p>The CURRENT_TIME function returns the current local time as a value of
type TIME.</p>
@@ -32055,7 +32061,7 @@ value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_current_time">7.32.1. Examples of CURRENT_TIME</h4>
+<h4 id="examples_of_current_time">7.33.1. Examples of CURRENT_TIME</h4>
<div class="ulist">
<ul>
<li>
@@ -32073,7 +32079,7 @@ VALUES (001, CURRENT_DATE, CURRENT_TIME, 'JuBrock');</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="current_timestamp_function">7.33. CURRENT_TIMESTAMP Function</h3>
+<h3 id="current_timestamp_function">7.34. CURRENT_TIMESTAMP Function</h3>
<div class="paragraph">
<p>The CURRENT_TIMESTAMP function returns a value of type TIMESTAMP based
on the current local date and time.</p>
@@ -32109,7 +32115,7 @@ returned is not a string value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_current_timestamp">7.33.1. Examples of CURRENT_TIMESTAMP</h4>
+<h4 id="examples_of_current_timestamp">7.34.1. Examples of CURRENT_TIMESTAMP</h4>
<div class="ulist">
<ul>
<li>
@@ -32128,7 +32134,7 @@ SET ship_timestamp = CURRENT_TIMESTAMP WHERE projcode = 1000;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="current_user_function">7.34. CURRENT_USER Function</h3>
+<h3 id="current_user_function">7.35. CURRENT_USER Function</h3>
<div class="paragraph">
<p>The CURRENT_USER function returns the database user name of the current
user who invoked the function. The current user is the authenticated
@@ -32144,7 +32150,7 @@ authorization of SQL statements in the current session.</p>
<p>The CURRENT_USER function is similar to the <a href="#user_function">USER Function</a>.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_current_user">7.34.1. Considerations for CURRENT_USER</h4>
+<h4 id="considerations_for_current_user">7.35.1. Considerations for CURRENT_USER</h4>
<div class="ulist">
<ul>
<li>
@@ -32157,7 +32163,7 @@ authorization of SQL statements in the current session.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_current_user">7.34.2. Examples of CURRENT_USER</h4>
+<h4 id="examples_of_current_user">7.35.2. Examples of CURRENT_USER</h4>
<div class="ulist">
<ul>
<li>
@@ -32180,7 +32186,7 @@ TSHAW
</div>
</div>
<div class="sect2">
-<h3 id="date_add_function">7.35. DATE_ADD Function</h3>
+<h3 id="date_add_function">7.36. DATE_ADD Function</h3>
<div class="paragraph">
<p>The DATE_ADD function adds the interval specified by
<em>interval_expression</em> to <em>datetime_expr</em>. If the specified interval is
@@ -32219,7 +32225,7 @@ expressions. See <a href="#interval_value_expressions">Interval Value Expression
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_date_add">7.35.1. Examples of DATE_ADD</h4>
+<h4 id="examples_of_date_add">7.36.1. Examples of DATE_ADD</h4>
<div class="ulist">
<ul>
<li>
@@ -32272,7 +32278,7 @@ compare this example with the last example under DATE_SUB.
</div>
</div>
<div class="sect2">
-<h3 id="date_sub_function">7.36. DATE_SUB Function</h3>
+<h3 id="date_sub_function">7.37. DATE_SUB Function</h3>
<div class="paragraph">
<p>The DATE_SUB function subtracts the specified <em>interval_expression</em> from
<em>datetime_expr</em>. If the specified interval is in years or months,
@@ -32312,7 +32318,7 @@ expressions. see <a href="#interval_value_expressions">Interval Value Expression
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_date_sub">7.36.1. Examples of DATE_SUB</h4>
+<h4 id="examples_of_date_sub">7.37.1. Examples of DATE_SUB</h4>
<div class="ulist">
<ul>
<li>
@@ -32353,7 +32359,7 @@ expressions. see <a href="#interval_value_expressions">Interval Value Expression
</div>
</div>
<div class="sect2">
-<h3 id="dateadd_function">7.37. DATEADD Function</h3>
+<h3 id="dateadd_function">7.38. DATEADD Function</h3>
<div class="paragraph">
<p>The DATEADD function adds the interval of time specified by <em>datepart</em>
and <em>num-expr</em> to <em>datetime-expr</em>. If the specified interval is in
@@ -32442,7 +32448,7 @@ returned. See <a href="#datetime_value_expressions">Datetime Value Expressions</
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_dateadd">7.37.1. Examples of DATEADD</h4>
+<h4 id="examples_of_dateadd">7.38.1. Examples of DATEADD</h4>
<div class="ulist">
<ul>
<li>
@@ -32483,7 +32489,7 @@ returned. See <a href="#datetime_value_expressions">Datetime Value Expressions</
</div>
</div>
<div class="sect2">
-<h3 id="datediff_function">7.38. DATEDIFF Function</h3>
+<h3 id="datediff_function">7.39. DATEDIFF Function</h3>
<div class="paragraph">
<p>The DATEDIFF function returns the integer value for the number of
<em>datepart</em> units of time between <em>startdate</em> and <em>enddate</em>.</p>
@@ -32498,7 +32504,7 @@ returned. See <a href="#datetime_value_expressions">Datetime Value Expressions</
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="syntax_description_of_datediff">7.38.1. Syntax Description of DATEDIFF</h4>
+<h4 id="syntax_description_of_datediff">7.39.1. Syntax Description of DATEDIFF</h4>
<div class="ulist">
<ul>
<li>
@@ -32566,7 +32572,7 @@ See <a href="#datetime_value_expressions">Datetime Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_datediff">7.38.2. Considerations for DATEDIFF</h4>
+<h4 id="considerations_for_datediff">7.39.2. Considerations for DATEDIFF</h4>
<div class="sect4">
<h5 id="boundary">Boundary</h5>
<div class="paragraph">
@@ -32659,7 +32665,7 @@ See <a href="#datetime_value_expressions">Datetime Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_datediff">7.38.3. Examples of DATEDIFF</h4>
+<h4 id="examples_of_datediff">7.39.3. Examples of DATEDIFF</h4>
<div class="sect4">
<h5 id="date_difference_in_second">Date Difference in SECOND</h5>
<div class="ulist">
@@ -32804,7 +32810,7 @@ FROM DUAL;</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="date_difference_in_year">7.38.4. Date Difference in YEAR</h4>
+<h4 id="date_difference_in_year">7.39.4. Date Difference in YEAR</h4>
<div class="ulist">
<ul>
<li>
@@ -32837,7 +32843,7 @@ FROM DUAL;</code></pre>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="dateformat_function">7.38.5. DATEFORMAT Function</h4>
+<h4 id="dateformat_function">7.39.5. DATEFORMAT Function</h4>
<div class="paragraph">
<p>The DATEFORMAT function returns a datetime value as a character string
literal in the DEFAULT, USA, or EUROPEAN format. The data type of the
@@ -32870,14 +32876,14 @@ or TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressio
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_dateformat">7.38.6. Considerations for DATEFORMAT</h4>
+<h4 id="considerations_for_dateformat">7.39.6. Considerations for DATEFORMAT</h4>
<div class="paragraph">
<p>The DATEFORMAT function returns the datetime value in ISO88591
encoding.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_dateformat">7.38.7. Examples of DATEFORMAT</h4>
+<h4 id="examples_of_dateformat">7.39.7. Examples of DATEFORMAT</h4>
<div class="ulist">
<ul>
<li>
@@ -32906,7 +32912,7 @@ function returns this string literal:</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_part_function_of_an_interval">7.39. DATE_PART Function (of an Interval)</h3>
+<h3 id="date_part_function_of_an_interval">7.40. DATE_PART Function (of an Interval)</h3>
<div class="paragraph">
<p>The DATE_PART function extracts the datetime field specified by <em>text</em>
from the <em>interval</em> value specified by <em>interval</em> and returns the result
@@ -32951,7 +32957,7 @@ quotes.</p>
<p>When SECOND is specified the fractional part of the second is returned.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_date_part">7.39.1. Examples of DATE_PART</h4>
+<h4 id="examples_of_date_part">7.40.1. Examples of DATE_PART</h4>
<div class="ulist">
<ul>
<li>
@@ -32984,7 +32990,7 @@ quotes.</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_part_function_of_a_timestamp">7.40. DATE_PART Function (of a Timestamp)</h3>
+<h3 id="date_part_function_of_a_timestamp">7.41. DATE_PART Function (of a Timestamp)</h3>
<div class="paragraph">
<p>The DATE_PART function extracts the datetime field specified by <em>text</em>
from the datetime value specified by <em>datetime_expr</em> and returns the
@@ -33050,7 +33056,7 @@ and YEARWEEK text specification with EXTRACT.</p>
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_date_part">7.40.1. Examples of DATE_PART</h4>
+<h4 id="examples_of_date_part">7.41.1. Examples of DATE_PART</h4>
<div class="ulist">
<ul>
<li>
@@ -33091,7 +33097,7 @@ and YEARWEEK text specification with EXTRACT.</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_trunc_function">7.41. DATE_TRUNC Function</h3>
+<h3 id="date_trunc_function">7.42. DATE_TRUNC Function</h3>
<div class="paragraph">
<p>The DATE_TRUNC function returns a value of type TIMESTAMP, which has all
fields of lesser precision than <em>text</em> set to zero (or 1 in the case of
@@ -33127,7 +33133,7 @@ months or days). See <a href="#datetime_value_expressions">Datetime Value Expres
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_date_trunc">7.41.1. Examples of DATE_TRUNC</h4>
+<h4 id="examples_of_date_trunc">7.42.1. Examples of DATE_TRUNC</h4>
<div class="ulist">
<ul>
<li>
@@ -33173,7 +33179,7 @@ months or days). See <a href="#datetime_value_expressions">Datetime Value Expres
</div>
</div>
<div class="sect2">
-<h3 id="day_function">7.42. DAY Function</h3>
+<h3 id="day_function">7.43. DAY Function</h3>
<div class="paragraph">
<p>The DAY function converts a DATE or TIMESTAMP expression into an INTEGER
value in the range 1 through 31 that represents the corresponding day of
@@ -33200,7 +33206,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_day">7.42.1. Examples of Day</h4>
+<h4 id="examples_of_day">7.43.1. Examples of Day</h4>
<div class="ulist">
<ul>
<li>
@@ -33224,7 +33230,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayname_function">7.43. DAYNAME Function</h3>
+<h3 id="dayname_function">7.44. DAYNAME Function</h3>
<div class="paragraph">
<p>The DAYNAME function converts a DATE or TIMESTAMP expression into a
character literal that is the name of the day of the week (Sunday,
@@ -33250,13 +33256,13 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_dayname">7.43.1. Considerations for DAYNAME</h4>
+<h4 id="considerations_for_dayname">7.44.1. Considerations for DAYNAME</h4>
<div class="paragraph">
<p>The DAYNAME function returns the name of the day in ISO88591.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_dayname">7.43.2. Examples of DAYNAME</h4>
+<h4 id="examples_of_dayname">7.44.2. Examples of DAYNAME</h4>
<div class="paragraph">
<p>Return the name of the day of the week from the start date column in the
project table:</p>
@@ -33279,7 +33285,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofmonth_function">7.44. DAYOFMONTH Function</h3>
+<h3 id="dayofmonth_function">7.45. DAYOFMONTH Function</h3>
<div class="paragraph">
<p>The DAYOFMONTH function converts a DATE or TIMESTAMP expression into an
INTEGER value in the range 1 through 31 that represents the
@@ -33306,7 +33312,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofmonth">7.44.1. Examples of DAYOFMONTH</h4>
+<h4 id="examples_of_dayofmonth">7.45.1. Examples of DAYOFMONTH</h4>
<div class="ulist">
<ul>
<li>
@@ -33330,7 +33336,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofweek_function">7.45. DAYOFWEEK Function</h3>
+<h3 id="dayofweek_function">7.46. DAYOFWEEK Function</h3>
<div class="paragraph">
<p>The DAYOFWEEK function converts a DATE or TIMESTAMP expression into an
INTEGER value in the range 1 through 7 that represents the corresponding
@@ -33357,7 +33363,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofweek">7.45.1. Examples of DAYOFWEEK</h4>
+<h4 id="examples_of_dayofweek">7.46.1. Examples of DAYOFWEEK</h4>
<div class="ulist">
<ul>
<li>
@@ -33384,7 +33390,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofyear_function">7.46. DAYOFYEAR Function</h3>
+<h3 id="dayofyear_function">7.47. DAYOFYEAR Function</h3>
<div class="paragraph">
<p>The DAYOFYEAR function converts a DATE or TIMESTAMP expression into an
INTEGER value in the range 1 through 366 that represents the
@@ -33410,7 +33416,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofyear">7.46.1. Examples of DAYOFYEAR</h4>
+<h4 id="examples_of_dayofyear">7.47.1. Examples of DAYOFYEAR</h4>
<div class="ulist">
<ul>
<li>
@@ -33434,7 +33440,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="Decode_function">7.47. DECODE Function</h3>
+<h3 id="Decode_function">7.48. DECODE Function</h3>
<div class="paragraph">
<p>The DECODE function compares <em>expr</em> to each <em>test_expr</em> value one by one
in the order provided. If <em>expr</em> is equal to a <em>test_expr</em>, then the
@@ -33479,7 +33485,7 @@ returned.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_decode">7.47.1. Considerations for DECODE</h4>
+<h4 id="considerations_for_decode">7.48.1. Considerations for DECODE</h4>
<div class="paragraph">
<p>In a DECODE function, two nulls are considered to be equivalent. If
<em>expr</em> is null, then the returned value is the <em>retval</em> of the first
@@ -33612,7 +33618,7 @@ other than what a CASE statement normally does.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="_examples_of_decode">7.47.2. Examples of DECODE</h4>
+<h4 id="_examples_of_decode">7.48.2. Examples of DECODE</h4>
<div class="ulist">
<ul>
<li>
@@ -33679,7 +33685,7 @@ value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="degrees_function">7.48. DEGREES Function</h3>
+<h3 id="degrees_function">7.49. DEGREES Function</h3>
<div class="paragraph">
<p>The DEGREES function converts a numeric value expression expressed in
radians to the number of degrees.</p>
@@ -33705,7 +33711,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_degrees">7.48.1. Examples of Degrees</h4>
+<h4 id="examples_of_degrees">7.49.1. Examples of Degrees</h4>
<div class="ulist">
<ul>
<li>
@@ -33731,7 +33737,7 @@ inverse of the function radians.</p>
</div>
</div>
<div class="sect2">
-<h3 id="diff1_function">7.49. DIFF1 Function</h3>
+<h3 id="diff1_function">7.50. DIFF1 Function</h3>
<div class="paragraph">
<p>The DIFF1 function is a sequence function that calculates the amount of
change in an expression from row to row in an intermediate result table
@@ -33775,7 +33781,7 @@ from row to row evenly over some unit of change (usually time) in
another column.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_diff1">7.49.1. Considerations for DIFF1</h4>
+<h4 id="considerations_for_diff1">7.50.1. Considerations for DIFF1</h4>
<div class="sect4">
<h5 id="equivalent-result">Equivalent Result</h5>
<div class="paragraph">
@@ -33806,7 +33812,7 @@ division by a value of INTERVAL data type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_diff1">7.49.2. Examples of DIFF1</h4>
+<h4 id="examples_of_diff1">7.50.2. Examples of DIFF1</h4>
<div class="ulist">
<ul>
<li>
@@ -33896,7 +33902,7 @@ example, 0.0007319 is equal to 21959 divided by 30002620.</p>
</div>
</div>
<div class="sect2">
-<h3 id="diff2_function">7.50. DIFF2 Function</h3>
+<h3 id="diff2_function">7.51. DIFF2 Function</h3>
<div class="paragraph">
<p>The DIFF2 function is a sequence function that calculates the amount of
change in a DIFF1 value from row to row in an intermediate result table
@@ -33936,7 +33942,7 @@ See <a href="#diff1_function">DIFF1 Function</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_diff2">7.50.1. Considerations for DIFF2</h4>
+<h4 id="considerations_for_diff2">7.51.1. Considerations for DIFF2</h4>
<div class="sect4">
<h5 id="equivalent_result_1">Equivalent Result</h5>
<div class="ulist">
@@ -33977,7 +33983,7 @@ division by a value of INTERVAL data type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_diff2">7.50.2. Examples of DIFF2</h4>
+<h4 id="examples_of_diff2">7.51.2. Examples of DIFF2</h4>
<div class="ulist">
<ul>
<li>
@@ -34035,9 +34041,9 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="emptyblob_function">7.51. EMPTY_BLOB() Function</h3>
+<h3 id="emptyblob_function">7.52. EMPTY_BLOB() Function</h3>
<div class="sect3">
-<h4 id="syntax_descriptions_of_emptyblob_function">7.51.1. Syntax Descriptions of EMPTY_BLOB() Function</h4>
+<h4 id="syntax_descriptions_of_emptyblob_function">7.52.1. Syntax Descriptions of EMPTY_BLOB() Function</h4>
<div class="paragraph">
<p>The EMPTY_BLOB() function creates a dummy LOB handle of type BLOB.</p>
</div>
@@ -34057,7 +34063,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_emptyblob_function">7.51.2. Considerations for EMPTY_BLOB() Function</h4>
+<h4 id="considerations_for_emptyblob_function">7.52.2. Considerations for EMPTY_BLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34093,7 +34099,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_emptyblob_function">7.51.3. Examples of EMPTY_BLOB() Function</h4>
+<h4 id="examples_of_emptyblob_function">7.52.3. Examples of EMPTY_BLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34110,9 +34116,9 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="emptyclob_function">7.52. EMPTY_CLOB() Function</h3>
+<h3 id="emptyclob_function">7.53. EMPTY_CLOB() Function</h3>
<div class="sect3">
-<h4 id="syntax_descriptions_of_emptyclob_function">7.52.1. Syntax Descriptions of EMPTY_CLOB() Function</h4>
+<h4 id="syntax_descriptions_of_emptyclob_function">7.53.1. Syntax Descriptions of EMPTY_CLOB() Function</h4>
<div class="paragraph">
<p>The EMPTY_CLOB() function creates a dummy LOB handle of type CLOB.</p>
</div>
@@ -34132,7 +34138,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_emptyclob_function">7.52.2. Considerations for EMPTY_CLOB() Function</h4>
+<h4 id="considerations_for_emptyclob_function">7.53.2. Considerations for EMPTY_CLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34158,7 +34164,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_emptyclob_function">7.52.3. Examples of EMPTY_CLOB() Function</h4>
+<h4 id="examples_of_emptyclob_function">7.53.3. Examples of EMPTY_CLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34175,7 +34181,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="exp_function">7.53. EXP Function</h3>
+<h3 id="exp_function">7.54. EXP Function</h3>
<div class="paragraph">
<p>This function returns the exponential value (to the base e) of a numeric
value expression. EXP is a Trafodion SQL extension.</p>
@@ -34205,7 +34211,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
709.78271289338405.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_exp">7.53.1. Examples of EXP</h4>
+<h4 id="examples_of_exp">7.54.1. Examples of EXP</h4>
<div class="ulist">
<ul>
<li>
@@ -34232,7 +34238,7 @@ of the function LOG:</p>
</div>
</div>
<div class="sect2">
-<h3 id="explain_function">7.54. EXPLAIN Function</h3>
+<h3 id="explain_function">7.55. EXPLAIN Function</h3>
<div class="paragraph">
<p>The EXPLAIN function is a table-valued stored function that generates a
result table describing an access plan for a SELECT, INSERT, DELETE, or
@@ -34292,7 +34298,7 @@ name in a PREPARE statement.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_explain_function">7.54.1. Considerations for EXPLAIN Function</h4>
+<h4 id="considerations_for_explain_function">7.55.1. Considerations for EXPLAIN Function</h4>
<div class="sect4">
<h5 id="using_a_statement_pattern">Using a Statement Pattern</h5>
<div class="paragraph">
@@ -34532,7 +34538,7 @@ a nested-loop join.</p></td>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_explain_function">7.54.2. Examples of EXPLAIN Function</h4>
+<h4 id="examples_of_explain_function">7.55.2. Examples of EXPLAIN Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34564,9 +34570,9 @@ then selects the desired columns.</p>
</div>
</div>
<div class="sect2">
-<h3 id="externaltolob_function">7.55. EXTERNALTOLOB Function</h3>
+<h3 id="externaltolob_function">7.56. EXTERNALTOLOB Function</h3>
<div class="sect3">
-<h4 id="externaltolob_function_syntax">7.55.1. Syntax Descriptions of EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_syntax">7.56.1. Syntax Descriptions of EXTERNALTOLOB Function</h4>
<div class="paragraph">
<p>The EXTERNALTOLOB function converts data from an external file into LOB format. This function can be used in an INSERT or UPDATE statement.</p>
</div>
@@ -34589,7 +34595,7 @@ hdfs:///{local hdfs file name}</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="externaltolob_function_considerations">7.55.2. Considerations for EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_considerations">7.56.2. Considerations for EXTERNALTOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34602,7 +34608,7 @@ hdfs:///{local hdfs file name}</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="externaltolob_function_examples">7.55.3. Examples of EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_examples">7.56.3. Examples of EXTERNALTOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34629,7 +34635,7 @@ externaltolob('hdfs:///lobs/lob_input_a1.txt'));</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="extract_function">7.56. EXTRACT Function</h3>
+<h3 id="extract_function">7.57. EXTRACT Function</h3>
<div class="paragraph">
<p>The EXTRACT function extracts a datetime field from a datetime or
interval value expression. It returns an exact numeric value.</p>
@@ -34660,7 +34666,7 @@ interval value expression. It returns an exact numeric value.</p>
<a href="#interval_value_expressions">Interval Value Expressions</a>.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_extract">7.56.1. Examples of EXTRACT</h4>
+<h4 id="examples_of_extract">7.57.1. Examples of EXTRACT</h4>
<div class="ulist">
<ul>
<li>
@@ -34691,9 +34697,9 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="filetolob_function">7.57. FILETOLOB Function</h3>
+<h3 id="filetolob_function">7.58. FILETOLOB Function</h3>
<div class="sect3">
-<h4 id="filetolob_function_syntax">7.57.1. Syntax Descriptions of FILETOLOB Function</h4>
+<h4 id="filetolob_function_syntax">7.58.1. Syntax Descriptions of FILETOLOB Function</h4>
<div class="paragraph">
<p>The FILETOLOB function converts data from a local linux/hdfs file into LOB format. This function can be used in an INSERT or UPDATE statement.</p>
</div>
@@ -34720,7 +34726,7 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect3">
-<h4 id="filetolob_function_examples">7.57.2. Examples of FILETOLOB Function</h4>
+<h4 id="filetolob_function_examples">7.58.2. Examples of FILETOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -34745,7 +34751,7 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="group_concat_function">7.58. GROUP_CONCAT Function</h3>
+<h3 id="group_concat_function">7.59. GROUP_CONCAT Function</h3>
<div class="paragraph">
<p>This function returns a string result with the concatenated non-NULL values from a group.
It returns NULL if there are no non-NULL values.
@@ -34770,7 +34776,7 @@ a separator explicitly, use SEPARATOR followed by the string literal value that
inserted between group values. To eliminate the separator altogether, specify SEPARATOR ''.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_group_concat">7.58.1. Examples of GROUP_CONCAT</h4>
+<h4 id="examples_of_group_concat">7.59.1. Examples of GROUP_CONCAT</h4>
<div class="paragraph">
<p>The following example returns concatenated strings for column test_score for each student.</p>
</div>
@@ -34791,7 +34797,7 @@ tom 91 77 43</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="hour_function">7.59. HOUR Function</h3>
+<h3 id="hour_function">7.60. HOUR Function</h3>
<div class="paragraph">
<p>The HOUR function converts a TIME or TIMESTAMP expression into an
INTEGER value in the range 0 through 23 that represents the
@@ -34817,7 +34823,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_hour">7.59.1. Examples of HOUR</h4>
+<h4 id="examples_of_hour">7.60.1. Examples of HOUR</h4>
<div class="ulist">
<ul>
<li>
@@ -34842,7 +34848,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="insert_function">7.60. INSERT Function</h3>
+<h3 id="insert_function">7.61. INSERT Function</h3>
<div class="paragraph">
<p>The INSERT function returns a character string where a specified number
of characters within the character string has been deleted, beginning at
@@ -34892,7 +34898,7 @@ or equal to the length of <em>char-expr-1</em>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_insert">7.60.1. Examples of INSERT</h4>
+<h4 id="examples_of_insert">7.61.1. Examples of INSERT</h4>
<div class="ulist">
<ul>
<li>
@@ -34926,7 +34932,7 @@ SALES REP
</div>
</div>
<div class="sect2">
-<h3 id="is_ipv4_function">7.61. IS_IPV4 Function</h3>
+<h3 id="is_ipv4_function">7.62. IS_IPV4 Function</h3>
<div class="paragraph">
<p>For a given argument, if it is a valid IPV4 string, IS_IPV4() returns 1 else returns 0.</p>
</div>
@@ -34949,7 +34955,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_is_ipv4">7.61.1. Examples of IS_IPV4</h4>
+<h4 id="examples_of_is_ipv4">7.62.1. Examples of IS_IPV4</h4>
<div class="paragraph">
<p>This function returns 1 for the first input argument, since it is a valid IPV4 string;
0 for the second input argument, since it is an invalid IPV4 string.</p>
@@ -34967,7 +34973,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="is_ipv6_function">7.62. IS_IPV6 Function</h3>
+<h3 id="is_ipv6_function">7.63. IS_IPV6 Function</h3>
<div class="paragraph">
<p>Returns 1 if the argument is a valid IPv6 address specified as a string, 0 otherwise.
This function does not consider IPv4 addresses to be valid IPv6 addresses.</p>
@@ -34991,7 +34997,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_is_ipv6">7.62.1. Examples of IS_IPV6</h4>
+<h4 id="examples_of_is_ipv6">7.63.1. Examples of IS_IPV6</h4>
<div class="paragraph">
<p>This function returns 0 for the second input argument, since it is a valid IPV6 string;
1 for the second input argument, since it is an invalid IPVr6 string.</p>
@@ -35007,7 +35013,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
<TRUNCATED>