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/04/30 15:59:01 UTC
[02/24] trafodion-site git commit: Merge [TRAFODION-3044] PR 1542 Add
ENABLE/DISABLE INDEX examples to SQL Ref
http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/af4e9151/docs/sql_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html
index 7499eb8..04fa99b 100644
--- a/docs/sql_reference/index.html
+++ b/docs/sql_reference/index.html
@@ -1418,583 +1418,585 @@ table.CodeRay td.code>pre{padding:0}
<li><a href="#syntax_description_of_datediff">7.40.1. Syntax Description of DATEDIFF</a></li>
<li><a href="#considerations_for_datediff">7.40.2. Considerations for DATEDIFF</a></li>
<li><a href="#examples_of_datediff">7.40.3. Examples of DATEDIFF</a></li>
-<li><a href="#date_difference_in_year">7.40.4. Date Difference in YEAR</a></li>
-<li><a href="#dateformat_function">7.40.5. DATEFORMAT Function</a></li>
-<li><a href="#considerations_for_dateformat">7.40.6. Considerations for DATEFORMAT</a></li>
-<li><a href="#examples_of_dateformat">7.40.7. Examples of DATEFORMAT</a></li>
</ul>
</li>
-<li><a href="#date_part_function_of_an_interval">7.41. DATE_PART Function (of an Interval)</a>
+<li><a href="#dateformat_function">7.41. DATEFORMAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_part">7.41.1. Examples of DATE_PART</a></li>
+<li><a href="#considerations_for_dateformat">7.41.1. Considerations for DATEFORMAT</a></li>
+<li><a href="#examples_of_dateformat">7.41.2. Examples of DATEFORMAT</a></li>
</ul>
</li>
-<li><a href="#date_part_function_of_a_timestamp">7.42. DATE_PART Function (of a Timestamp)</a>
+<li><a href="#date_part_function_of_an_interval">7.42. DATE_PART Function (of an Interval)</a>
<ul class="sectlevel3">
<li><a href="#examples_of_date_part">7.42.1. Examples of DATE_PART</a></li>
</ul>
</li>
-<li><a href="#date_trunc_function">7.43. DATE_TRUNC Function</a>
+<li><a href="#date_part_function_of_a_timestamp">7.43. DATE_PART Function (of a Timestamp)</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_trunc">7.43.1. Examples of DATE_TRUNC</a></li>
+<li><a href="#examples_of_date_part">7.43.1. Examples of DATE_PART</a></li>
</ul>
</li>
-<li><a href="#day_function">7.44. DAY Function</a>
+<li><a href="#date_trunc_function">7.44. DATE_TRUNC Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_day">7.44.1. Examples of Day</a></li>
+<li><a href="#examples_of_date_trunc">7.44.1. Examples of DATE_TRUNC</a></li>
</ul>
</li>
-<li><a href="#dayname_function">7.45. DAYNAME Function</a>
+<li><a href="#day_function">7.45. DAY Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_dayname">7.45.1. Considerations for DAYNAME</a></li>
-<li><a href="#examples_of_dayname">7.45.2. Examples of DAYNAME</a></li>
+<li><a href="#examples_of_day">7.45.1. Examples of Day</a></li>
</ul>
</li>
-<li><a href="#dayofmonth_function">7.46. DAYOFMONTH Function</a>
+<li><a href="#dayname_function">7.46. DAYNAME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofmonth">7.46.1. Examples of DAYOFMONTH</a></li>
+<li><a href="#considerations_for_dayname">7.46.1. Considerations for DAYNAME</a></li>
+<li><a href="#examples_of_dayname">7.46.2. Examples of DAYNAME</a></li>
</ul>
</li>
-<li><a href="#dayofweek_function">7.47. DAYOFWEEK Function</a>
+<li><a href="#dayofmonth_function">7.47. DAYOFMONTH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofweek">7.47.1. Examples of DAYOFWEEK</a></li>
+<li><a href="#examples_of_dayofmonth">7.47.1. Examples of DAYOFMONTH</a></li>
</ul>
</li>
-<li><a href="#dayofyear_function">7.48. DAYOFYEAR Function</a>
+<li><a href="#dayofweek_function">7.48. DAYOFWEEK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofyear">7.48.1. Examples of DAYOFYEAR</a></li>
+<li><a href="#examples_of_dayofweek">7.48.1. Examples of DAYOFWEEK</a></li>
</ul>
</li>
-<li><a href="#Decode_function">7.49. DECODE Function</a>
+<li><a href="#dayofyear_function">7.49. DAYOFYEAR Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_decode">7.49.1. Considerations for DECODE</a></li>
-<li><a href="#_examples_of_decode">7.49.2. Examples of DECODE</a></li>
+<li><a href="#examples_of_dayofyear">7.49.1. Examples of DAYOFYEAR</a></li>
</ul>
</li>
-<li><a href="#degrees_function">7.50. DEGREES Function</a>
+<li><a href="#Decode_function">7.50. DECODE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_degrees">7.50.1. Examples of Degrees</a></li>
+<li><a href="#considerations_for_decode">7.50.1. Considerations for DECODE</a></li>
+<li><a href="#_examples_of_decode">7.50.2. Examples of DECODE</a></li>
</ul>
</li>
-<li><a href="#diff1_function">7.51. DIFF1 Function</a>
+<li><a href="#degrees_function">7.51. DEGREES Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_diff1">7.51.1. Considerations for DIFF1</a></li>
-<li><a href="#examples_of_diff1">7.51.2. Examples of DIFF1</a></li>
+<li><a href="#examples_of_degrees">7.51.1. Examples of Degrees</a></li>
</ul>
</li>
-<li><a href="#diff2_function">7.52. DIFF2 Function</a>
+<li><a href="#diff1_function">7.52. DIFF1 Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_diff2">7.52.1. Considerations for DIFF2</a></li>
-<li><a href="#examples_of_diff2">7.52.2. Examples of DIFF2</a></li>
+<li><a href="#considerations_for_diff1">7.52.1. Considerations for DIFF1</a></li>
+<li><a href="#examples_of_diff1">7.52.2. Examples of DIFF1</a></li>
</ul>
</li>
-<li><a href="#emptyblob_function">7.53. EMPTY_BLOB() Function</a>
+<li><a href="#diff2_function">7.53. DIFF2 Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_descriptions_of_emptyblob_function">7.53.1. Syntax Descriptions of EMPTY_BLOB() Function</a></li>
-<li><a href="#considerations_for_emptyblob_function">7.53.2. Considerations for EMPTY_BLOB() Function</a></li>
-<li><a href="#examples_of_emptyblob_function">7.53.3. Examples of EMPTY_BLOB() Function</a></li>
+<li><a href="#considerations_for_diff2">7.53.1. Considerations for DIFF2</a></li>
+<li><a href="#examples_of_diff2">7.53.2. Examples of DIFF2</a></li>
</ul>
</li>
-<li><a href="#emptyclob_function">7.54. EMPTY_CLOB() Function</a>
+<li><a href="#emptyblob_function">7.54. EMPTY_BLOB() Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_descriptions_of_emptyclob_function">7.54.1. Syntax Descriptions of EMPTY_CLOB() Function</a></li>
-<li><a href="#considerations_for_emptyclob_function">7.54.2. Considerations for EMPTY_CLOB() Function</a></li>
-<li><a href="#examples_of_emptyclob_function">7.54.3. Examples of EMPTY_CLOB() Function</a></li>
+<li><a href="#syntax_descriptions_of_emptyblob_function">7.54.1. Syntax Descriptions of EMPTY_BLOB() Function</a></li>
+<li><a href="#considerations_for_emptyblob_function">7.54.2. Considerations for EMPTY_BLOB() Function</a></li>
+<li><a href="#examples_of_emptyblob_function">7.54.3. Examples of EMPTY_BLOB() Function</a></li>
</ul>
</li>
-<li><a href="#exp_function">7.55. EXP Function</a>
+<li><a href="#emptyclob_function">7.55. EMPTY_CLOB() Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_exp">7.55.1. Examples of EXP</a></li>
+<li><a href="#syntax_descriptions_of_emptyclob_function">7.55.1. Syntax Descriptions of EMPTY_CLOB() Function</a></li>
+<li><a href="#considerations_for_emptyclob_function">7.55.2. Considerations for EMPTY_CLOB() Function</a></li>
+<li><a href="#examples_of_emptyclob_function">7.55.3. Examples of EMPTY_CLOB() Function</a></li>
</ul>
</li>
-<li><a href="#explain_function">7.56. EXPLAIN Function</a>
+<li><a href="#exp_function">7.56. EXP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_explain_function">7.56.1. Considerations for EXPLAIN Function</a></li>
-<li><a href="#examples_of_explain_function">7.56.2. Examples of EXPLAIN Function</a></li>
+<li><a href="#examples_of_exp">7.56.1. Examples of EXP</a></li>
</ul>
</li>
-<li><a href="#externaltolob_function">7.57. EXTERNALTOLOB Function</a>
+<li><a href="#explain_function">7.57. EXPLAIN Function</a>
<ul class="sectlevel3">
-<li><a href="#externaltolob_function_syntax">7.57.1. Syntax Descriptions of EXTERNALTOLOB Function</a></li>
-<li><a href="#externaltolob_function_considerations">7.57.2. Considerations for EXTERNALTOLOB Function</a></li>
-<li><a href="#externaltolob_function_examples">7.57.3. Examples of EXTERNALTOLOB Function</a></li>
+<li><a href="#considerations_for_explain_function">7.57.1. Considerations for EXPLAIN Function</a></li>
+<li><a href="#examples_of_explain_function">7.57.2. Examples of EXPLAIN Function</a></li>
</ul>
</li>
-<li><a href="#extract_function">7.58. EXTRACT Function</a>
+<li><a href="#externaltolob_function">7.58. EXTERNALTOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_extract">7.58.1. Examples of EXTRACT</a></li>
+<li><a href="#externaltolob_function_syntax">7.58.1. Syntax Descriptions of EXTERNALTOLOB Function</a></li>
+<li><a href="#externaltolob_function_considerations">7.58.2. Considerations for EXTERNALTOLOB Function</a></li>
+<li><a href="#externaltolob_function_examples">7.58.3. Examples of EXTERNALTOLOB Function</a></li>
</ul>
</li>
-<li><a href="#filetolob_function">7.59. FILETOLOB Function</a>
+<li><a href="#extract_function">7.59. EXTRACT Function</a>
<ul class="sectlevel3">
-<li><a href="#filetolob_function_syntax">7.59.1. Syntax Descriptions of FILETOLOB Function</a></li>
-<li><a href="#filetolob_function_examples">7.59.2. Examples of FILETOLOB Function</a></li>
+<li><a href="#examples_of_extract">7.59.1. Examples of EXTRACT</a></li>
</ul>
</li>
-<li><a href="#group_concat_function">7.60. GROUP_CONCAT Function</a>
+<li><a href="#filetolob_function">7.60. FILETOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_group_concat">7.60.1. Examples of GROUP_CONCAT</a></li>
+<li><a href="#filetolob_function_syntax">7.60.1. Syntax Descriptions of FILETOLOB Function</a></li>
+<li><a href="#filetolob_function_examples">7.60.2. Examples of FILETOLOB Function</a></li>
</ul>
</li>
-<li><a href="#hour_function">7.61. HOUR Function</a>
+<li><a href="#group_concat_function">7.61. GROUP_CONCAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_hour">7.61.1. Examples of HOUR</a></li>
+<li><a href="#examples_of_group_concat">7.61.1. Examples of GROUP_CONCAT</a></li>
</ul>
</li>
-<li><a href="#insert_function">7.62. INSERT Function</a>
+<li><a href="#hour_function">7.62. HOUR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_insert">7.62.1. Examples of INSERT</a></li>
+<li><a href="#examples_of_hour">7.62.1. Examples of HOUR</a></li>
</ul>
</li>
-<li><a href="#is_ipv4_function">7.63. IS_IPV4 Function</a>
+<li><a href="#insert_function">7.63. INSERT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_is_ipv4">7.63.1. Examples of IS_IPV4</a></li>
+<li><a href="#examples_of_insert">7.63.1. Examples of INSERT</a></li>
</ul>
</li>
-<li><a href="#is_ipv6_function">7.64. IS_IPV6 Function</a>
+<li><a href="#is_ipv4_function">7.64. IS_IPV4 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_is_ipv6">7.64.1. Examples of IS_IPV6</a></li>
+<li><a href="#examples_of_is_ipv4">7.64.1. Examples of IS_IPV4</a></li>
</ul>
</li>
-<li><a href="#inet_aton_function">7.65. INET_ATON Function</a>
+<li><a href="#is_ipv6_function">7.65. IS_IPV6 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_inet_aton">7.65.1. Examples of INET_ATON</a></li>
+<li><a href="#examples_of_is_ipv6">7.65.1. Examples of IS_IPV6</a></li>
</ul>
</li>
-<li><a href="#inet_ntoa_function">7.66. INET_NTOA Function</a>
+<li><a href="#inet_aton_function">7.66. INET_ATON Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_inet_ntoa">7.66.1. Examples of INET_NTOA</a></li>
+<li><a href="#examples_of_inet_aton">7.66.1. Examples of INET_ATON</a></li>
</ul>
</li>
-<li><a href="#isnull_function">7.67. ISNULL Function</a>
+<li><a href="#inet_ntoa_function">7.67. INET_NTOA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_isnull">7.67.1. Examples of ISNULL</a></li>
+<li><a href="#examples_of_inet_ntoa">7.67.1. Examples of INET_NTOA</a></li>
</ul>
</li>
-<li><a href="#juliantimestamp_function">7.68. JULIANTIMESTAMP Function</a>
+<li><a href="#isnull_function">7.68. ISNULL Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_juliantimestamp">7.68.1. Considerations for JULIANTIMESTAMP</a></li>
-<li><a href="#examples_of_juliantimestamp">7.68.2. Examples of JULIANTIMESTAMP</a></li>
+<li><a href="#examples_of_isnull">7.68.1. Examples of ISNULL</a></li>
</ul>
</li>
-<li><a href="#lastnotnull_function">7.69. LASTNOTNULL Function</a>
+<li><a href="#juliantimestamp_function">7.69. JULIANTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_lastnotnull">7.69.1. Examples of LASTNOTNULL</a></li>
+<li><a href="#considerations_for_juliantimestamp">7.69.1. Considerations for JULIANTIMESTAMP</a></li>
+<li><a href="#examples_of_juliantimestamp">7.69.2. Examples of JULIANTIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#lcase_function">7.70. LCASE Function</a>
+<li><a href="#lastnotnull_function">7.70. LASTNOTNULL Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_lcase">7.70.1. Examples of LCASE</a></li>
-<li><a href="#left_function">7.70.2. LEFT Function</a></li>
-<li><a href="#examples_of_left">7.70.3. Examples of LEFT</a></li>
+<li><a href="#examples_of_lastnotnull">7.70.1. Examples of LASTNOTNULL</a></li>
</ul>
</li>
-<li><a href="#locate_function">7.71. LOCATE Function</a>
+<li><a href="#lcase_function">7.71. LCASE Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_locate">7.71.1. Considerations for LOCATE</a></li>
-<li><a href="#examples_of_locate">7.71.2. Examples of LOCATE</a></li>
+<li><a href="#examples_of_lcase">7.71.1. Examples of LCASE</a></li>
+<li><a href="#left_function">7.71.2. LEFT Function</a></li>
+<li><a href="#examples_of_left">7.71.3. Examples of LEFT</a></li>
</ul>
</li>
-<li><a href="#log_function">7.72. LOG Function</a>
+<li><a href="#locate_function">7.72. LOCATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_log">7.72.1. Examples of LOG</a></li>
-<li><a href="#log10_function">7.72.2. LOG10 Function</a></li>
-<li><a href="#examples_of_log10">7.72.3. Examples of LOG10</a></li>
+<li><a href="#considerations_for_locate">7.72.1. Considerations for LOCATE</a></li>
+<li><a href="#examples_of_locate">7.72.2. Examples of LOCATE</a></li>
</ul>
</li>
-<li><a href="#lower_function">7.73. LOWER Function</a>
+<li><a href="#log_function">7.73. LOG Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_lower">7.73.1. Considerations for LOWER</a></li>
-<li><a href="#examples_of_lower">7.73.2. Examples of LOWER</a></li>
+<li><a href="#examples_of_log">7.73.1. Examples of LOG</a></li>
+<li><a href="#log10_function">7.73.2. LOG10 Function</a></li>
+<li><a href="#examples_of_log10">7.73.3. Examples of LOG10</a></li>
</ul>
</li>
-<li><a href="#lpad_function">7.74. LPAD Function</a>
+<li><a href="#lower_function">7.74. LOWER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_lpad">7.74.1. Examples of LPAD</a></li>
+<li><a href="#considerations_for_lower">7.74.1. Considerations for LOWER</a></li>
+<li><a href="#examples_of_lower">7.74.2. Examples of LOWER</a></li>
</ul>
</li>
-<li><a href="#ltrim_function">7.75. LTRIM Function</a>
+<li><a href="#lpad_function">7.75. LPAD Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_ltrim">7.75.1. Considerations for LTRIM</a></li>
-<li><a href="#examples_of_ltrim">7.75.2. Examples of LTRIM</a></li>
+<li><a href="#examples_of_lpad">7.75.1. Examples of LPAD</a></li>
</ul>
</li>
-<li><a href="#max_function">7.76. MAX/MAXIMUM Function</a>
+<li><a href="#ltrim_function">7.76. LTRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_max">7.76.1. Considerations for MAX/MAXIMUM</a></li>
-<li><a href="#operands_of_the_expression">7.76.2. Operands of the Expression</a></li>
-<li><a href="#examples_of_max">7.76.3. Examples of MAX/MAXIMUM</a></li>
+<li><a href="#considerations_for_ltrim">7.76.1. Considerations for LTRIM</a></li>
+<li><a href="#examples_of_ltrim">7.76.2. Examples of LTRIM</a></li>
</ul>
</li>
-<li><a href="#md5_function">7.77. MD5 Function</a>
+<li><a href="#max_function">7.77. MAX/MAXIMUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_md5">7.77.1. Examples of MD5</a></li>
+<li><a href="#considerations_for_max">7.77.1. Considerations for MAX/MAXIMUM</a></li>
+<li><a href="#operands_of_the_expression">7.77.2. Operands of the Expression</a></li>
+<li><a href="#examples_of_max">7.77.3. Examples of MAX/MAXIMUM</a></li>
</ul>
</li>
-<li><a href="#min_function">7.78. MIN Function</a>
+<li><a href="#md5_function">7.78. MD5 Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_min">7.78.1. Considerations for MIN</a></li>
-<li><a href="#examples_of_min">7.78.2. Examples of MIN</a></li>
+<li><a href="#examples_of_md5">7.78.1. Examples of MD5</a></li>
</ul>
</li>
-<li><a href="#minute_function">7.79. MINUTE Function</a>
+<li><a href="#min_function">7.79. MIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_minute">7.79.1. Examples of minute</a></li>
+<li><a href="#considerations_for_min">7.79.1. Considerations for MIN</a></li>
+<li><a href="#examples_of_min">7.79.2. Examples of MIN</a></li>
</ul>
</li>
-<li><a href="#mod_function">7.80. MOD Function</a>
+<li><a href="#minute_function">7.80. MINUTE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_mod">7.80.1. Examples of MOD</a></li>
+<li><a href="#examples_of_minute">7.80.1. Examples of minute</a></li>
</ul>
</li>
-<li><a href="#month_function">7.81. MONTH Function</a>
+<li><a href="#mod_function">7.81. MOD Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_month">7.81.1. Examples of MONTH</a></li>
+<li><a href="#examples_of_mod">7.81.1. Examples of MOD</a></li>
</ul>
</li>
-<li><a href="#monthname_function">7.82. MONTHNAME Function</a>
+<li><a href="#month_function">7.82. MONTH Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_monthname">7.82.1. Considerations for MONTHNAME</a></li>
-<li><a href="#examples_of_monthname">7.82.2. Examples of MONTHNAME</a></li>
+<li><a href="#examples_of_month">7.82.1. Examples of MONTH</a></li>
</ul>
</li>
-<li><a href="#movingavg_function">7.83. MOVINGAVG Function</a>
+<li><a href="#monthname_function">7.83. MONTHNAME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingavg">7.83.1. Examples of MOVINGAVG</a></li>
+<li><a href="#considerations_for_monthname">7.83.1. Considerations for MONTHNAME</a></li>
+<li><a href="#examples_of_monthname">7.83.2. Examples of MONTHNAME</a></li>
</ul>
</li>
-<li><a href="#movingcount_function">7.84. MOVINGCOUNT Function</a>
+<li><a href="#movingavg_function">7.84. MOVINGAVG Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_movingcount">7.84.1. Considerations for MOVINGCOUNT</a></li>
-<li><a href="#examples_of_movingcount">7.84.2. Examples of MOVINGCOUNT</a></li>
+<li><a href="#examples_of_movingavg">7.84.1. Examples of MOVINGAVG</a></li>
</ul>
</li>
-<li><a href="#movingmax_function">7.85. MOVINGMAX Function</a>
+<li><a href="#movingcount_function">7.85. MOVINGCOUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingmax">7.85.1. Examples of MOVINGMAX</a></li>
+<li><a href="#considerations_for_movingcount">7.85.1. Considerations for MOVINGCOUNT</a></li>
+<li><a href="#examples_of_movingcount">7.85.2. Examples of MOVINGCOUNT</a></li>
</ul>
</li>
-<li><a href="#movingmin_function">7.86. MOVINGMIN Function</a>
+<li><a href="#movingmax_function">7.86. MOVINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingmin">7.86.1. Examples of MOVINGMIN</a></li>
+<li><a href="#examples_of_movingmax">7.86.1. Examples of MOVINGMAX</a></li>
</ul>
</li>
-<li><a href="#movingstddev_function">7.87. MOVINGSTDDEV Function</a>
+<li><a href="#movingmin_function">7.87. MOVINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingstddev">7.87.1. Examples of MOVINGSTDDEV</a></li>
+<li><a href="#examples_of_movingmin">7.87.1. Examples of MOVINGMIN</a></li>
</ul>
</li>
-<li><a href="#movingsum_function">7.88. MOVINGSUM Function</a>
+<li><a href="#movingstddev_function">7.88. MOVINGSTDDEV Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingsum">7.88.1. Examples of MOVINGSUM</a></li>
+<li><a href="#examples_of_movingstddev">7.88.1. Examples of MOVINGSTDDEV</a></li>
</ul>
</li>
-<li><a href="#movingvariance_function">7.89. MOVINGVARIANCE Function</a>
+<li><a href="#movingsum_function">7.89. MOVINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingvariance">7.89.1. Examples of MOVINGVARIANCE</a></li>
-<li><a href="#nullif_function">7.89.2. NULLIF Function</a></li>
-<li><a href="#examples_of_nullif">7.89.3. Examples of NULLIF</a></li>
+<li><a href="#examples_of_movingsum">7.89.1. Examples of MOVINGSUM</a></li>
</ul>
</li>
-<li><a href="#nullifzero_function">7.90. NULLIFZERO Function</a>
+<li><a href="#movingvariance_function">7.90. MOVINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_nullifzero">7.90.1. Examples of NULLIFZERO</a></li>
+<li><a href="#examples_of_movingvariance">7.90.1. Examples of MOVINGVARIANCE</a></li>
+<li><a href="#nullif_function">7.90.2. NULLIF Function</a></li>
+<li><a href="#examples_of_nullif">7.90.3. Examples of NULLIF</a></li>
</ul>
</li>
-<li><a href="#nvl_function">7.91. NVL Function</a>
+<li><a href="#nullifzero_function">7.91. NULLIFZERO Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_nvl">7.91.1. Examples of NVL</a></li>
+<li><a href="#examples_of_nullifzero">7.91.1. Examples of NULLIFZERO</a></li>
</ul>
</li>
-<li><a href="#octet_length_function">7.92. OCTET_LENGTH Function</a>
+<li><a href="#nvl_function">7.92. NVL Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_octet_length">7.92.1. Considerations for OCTET_LENGTH</a></li>
-<li><a href="#offset_function">7.92.2. OFFSET Function</a></li>
-<li><a href="#examples_of_offset">7.92.3. Examples of OFFSET</a></li>
+<li><a href="#examples_of_nvl">7.92.1. Examples of NVL</a></li>
</ul>
</li>
-<li><a href="#pi_function">7.93. PI Function</a>
+<li><a href="#octet_length_function">7.93. OCTET_LENGTH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_pi">7.93.1. Examples of PI</a></li>
+<li><a href="#considerations_for_octet_length">7.93.1. Considerations for OCTET_LENGTH</a></li>
+<li><a href="#offset_function">7.93.2. OFFSET Function</a></li>
+<li><a href="#examples_of_offset">7.93.3. Examples of OFFSET</a></li>
</ul>
</li>
-<li><a href="#position_function">7.94. POSITION Function</a>
+<li><a href="#pi_function">7.94. PI Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_position">7.94.1. Considerations for POSITION</a></li>
-<li><a href="#examples_of_position">7.94.2. Examples of POSITION</a></li>
+<li><a href="#examples_of_pi">7.94.1. Examples of PI</a></li>
</ul>
</li>
-<li><a href="#power_function">7.95. POWER Function</a>
+<li><a href="#position_function">7.95. POSITION Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_power">7.95.1. Examples of POWER</a></li>
+<li><a href="#considerations_for_position">7.95.1. Considerations for POSITION</a></li>
+<li><a href="#examples_of_position">7.95.2. Examples of POSITION</a></li>
</ul>
</li>
-<li><a href="#quarter_function">7.96. QUARTER Function</a>
+<li><a href="#power_function">7.96. POWER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_quarter">7.96.1. Examples of QUARTER</a></li>
+<li><a href="#examples_of_power">7.96.1. Examples of POWER</a></li>
</ul>
</li>
-<li><a href="#radians_function">7.97. RADIANS Function</a>
+<li><a href="#quarter_function">7.97. QUARTER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_radians">7.97.1. Examples of RADIANS</a></li>
+<li><a href="#examples_of_quarter">7.97.1. Examples of QUARTER</a></li>
</ul>
</li>
-<li><a href="#runningrank_function">7.98. RANK/RUNNINGRANK Function</a>
+<li><a href="#radians_function">7.98. RADIANS Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningrank">7.98.1. Considerations for RANK/RUNNINGRANK</a></li>
-<li><a href="#examples_of_runningrank">7.98.2. Examples of RANK/RUNNINGRANK</a></li>
+<li><a href="#examples_of_radians">7.98.1. Examples of RADIANS</a></li>
</ul>
</li>
-<li><a href="#repeat_function">7.99. REPEAT Function</a>
+<li><a href="#runningrank_function">7.99. RANK/RUNNINGRANK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_repeat">7.99.1. Examples of REPEAT</a></li>
+<li><a href="#considerations_for_runningrank">7.99.1. Considerations for RANK/RUNNINGRANK</a></li>
+<li><a href="#examples_of_runningrank">7.99.2. Examples of RANK/RUNNINGRANK</a></li>
</ul>
</li>
-<li><a href="#replace_function">7.100. REPLACE Function</a>
+<li><a href="#repeat_function">7.100. REPEAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_replace">7.100.1. Examples of REPLACE</a></li>
+<li><a href="#examples_of_repeat">7.100.1. Examples of REPEAT</a></li>
</ul>
</li>
-<li><a href="#right_function">7.101. RIGHT Function</a>
+<li><a href="#replace_function">7.101. REPLACE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_right">7.101.1. Examples of RIGHT</a></li>
+<li><a href="#examples_of_replace">7.101.1. Examples of REPLACE</a></li>
</ul>
</li>
-<li><a href="#rollup_function">7.102. ROLLUP Function</a>
+<li><a href="#right_function">7.102. RIGHT Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rollup">7.102.1. Considerations for ROLLUP</a></li>
-<li><a href="#examples_of_rollup">7.102.2. Examples of ROLLUP</a></li>
+<li><a href="#examples_of_right">7.102.1. Examples of RIGHT</a></li>
</ul>
</li>
-<li><a href="#round_function">7.103. ROUND Function</a>
+<li><a href="#rollup_function">7.103. ROLLUP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_round">7.103.1. Examples of ROUND</a></li>
+<li><a href="#considerations_for_rollup">7.103.1. Considerations for ROLLUP</a></li>
+<li><a href="#examples_of_rollup">7.103.2. Examples of ROLLUP</a></li>
</ul>
</li>
-<li><a href="#rows_since_function">7.104. ROWS SINCE Function</a>
+<li><a href="#round_function">7.104. ROUND Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rows_since">7.104.1. Considerations for ROWS SINCE</a></li>
-<li><a href="#examples_of_rows_since">7.104.2. Examples of ROWS SINCE</a></li>
+<li><a href="#examples_of_round">7.104.1. Examples of ROUND</a></li>
</ul>
</li>
-<li><a href="#rows_since_changed_function">7.105. ROWS SINCE CHANGED Function</a>
+<li><a href="#rows_since_function">7.105. ROWS SINCE Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rows_since_changed">7.105.1. Considerations for ROWS SINCE CHANGED</a></li>
-<li><a href="#examples_of_rows_since_changed">7.105.2. Examples of ROWS SINCE CHANGED</a></li>
+<li><a href="#considerations_for_rows_since">7.105.1. Considerations for ROWS SINCE</a></li>
+<li><a href="#examples_of_rows_since">7.105.2. Examples of ROWS SINCE</a></li>
</ul>
</li>
-<li><a href="#rpad_function">7.106. RPAD Function</a>
+<li><a href="#rows_since_changed_function">7.106. ROWS SINCE CHANGED Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_rpad_function">7.106.1. Examples of RPAD Function</a></li>
+<li><a href="#considerations_for_rows_since_changed">7.106.1. Considerations for ROWS SINCE CHANGED</a></li>
+<li><a href="#examples_of_rows_since_changed">7.106.2. Examples of ROWS SINCE CHANGED</a></li>
</ul>
</li>
-<li><a href="#rtrim_function">7.107. RTRIM Function</a>
+<li><a href="#rpad_function">7.107. RPAD Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_rtrim">7.107.1. Considerations for RTRIM</a></li>
-<li><a href="#examples_of_rtrim">7.107.2. Examples of RTRIM</a></li>
+<li><a href="#examples_of_rpad_function">7.107.1. Examples of RPAD Function</a></li>
</ul>
</li>
-<li><a href="#runningavg_function">7.108. RUNNINGAVG Function</a>
+<li><a href="#rtrim_function">7.108. RTRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningavg">7.108.1. Considerations for RUNNINGAVG</a></li>
-<li><a href="#examples_of_runningavg">7.108.2. Examples of RUNNINGAVG</a></li>
+<li><a href="#considerations_for_rtrim">7.108.1. Considerations for RTRIM</a></li>
+<li><a href="#examples_of_rtrim">7.108.2. Examples of RTRIM</a></li>
</ul>
</li>
-<li><a href="#runningcount_function">7.109. RUNNINGCOUNT Function</a>
+<li><a href="#runningavg_function">7.109. RUNNINGAVG Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningcount">7.109.1. Considerations for RUNNINGCOUNT</a></li>
-<li><a href="#examples_of_runningcount">7.109.2. Examples of RUNNINGCOUNT</a></li>
+<li><a href="#considerations_for_runningavg">7.109.1. Considerations for RUNNINGAVG</a></li>
+<li><a href="#examples_of_runningavg">7.109.2. Examples of RUNNINGAVG</a></li>
</ul>
</li>
-<li><a href="#runningmax_function">7.110. RUNNINGMAX Function</a>
+<li><a href="#runningcount_function">7.110. RUNNINGCOUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmax">7.110.1. Examples of RUNNINGMAX</a></li>
+<li><a href="#considerations_for_runningcount">7.110.1. Considerations for RUNNINGCOUNT</a></li>
+<li><a href="#examples_of_runningcount">7.110.2. Examples of RUNNINGCOUNT</a></li>
</ul>
</li>
-<li><a href="#runningmin_function">7.111. RUNNINGMIN Function</a>
+<li><a href="#runningmax_function">7.111. RUNNINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmin">7.111.1. Examples of RUNNINGMIN</a></li>
-<li><a href="#runningstddev_function">7.111.2. RUNNINGSTDDEV Function</a></li>
-<li><a href="#considerations_for_runningstddev">7.111.3. Considerations for RUNNINGSTDDEV</a></li>
-<li><a href="#examples_of_runningstddev">7.111.4. Examples of RUNNINGSTDDEV</a></li>
+<li><a href="#examples_of_runningmax">7.111.1. Examples of RUNNINGMAX</a></li>
</ul>
</li>
-<li><a href="#runningsum_function">7.112. RUNNINGSUM Function</a>
+<li><a href="#runningmin_function">7.112. RUNNINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningsum">7.112.1. Examples of RUNNINGSUM</a></li>
+<li><a href="#examples_of_runningmin">7.112.1. Examples of RUNNINGMIN</a></li>
+<li><a href="#runningstddev_function">7.112.2. RUNNINGSTDDEV Function</a></li>
+<li><a href="#considerations_for_runningstddev">7.112.3. Considerations for RUNNINGSTDDEV</a></li>
+<li><a href="#examples_of_runningstddev">7.112.4. Examples of RUNNINGSTDDEV</a></li>
</ul>
</li>
-<li><a href="#runningvariance_function">7.113. RUNNINGVARIANCE Function</a>
+<li><a href="#runningsum_function">7.113. RUNNINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningvariance">7.113.1. Examples of RUNNINGVARIANCE</a></li>
+<li><a href="#examples_of_runningsum">7.113.1. Examples of RUNNINGSUM</a></li>
</ul>
</li>
-<li><a href="#second_function">7.114. SECOND Function</a>
+<li><a href="#runningvariance_function">7.114. RUNNINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_second">7.114.1. Examples of SECOND</a></li>
+<li><a href="#examples_of_runningvariance">7.114.1. Examples of RUNNINGVARIANCE</a></li>
</ul>
</li>
-<li><a href="#sha_function">7.115. SHA Function</a>
+<li><a href="#second_function">7.115. SECOND Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha">7.115.1. examples of SHA</a></li>
+<li><a href="#examples_of_second">7.115.1. Examples of SECOND</a></li>
</ul>
</li>
-<li><a href="#sha2_function">7.116. SHA2 Function</a>
+<li><a href="#sha_function">7.116. SHA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha2">7.116.1. examples of SHA2</a></li>
+<li><a href="#examples_of_sha">7.116.1. examples of SHA</a></li>
</ul>
</li>
-<li><a href="#sign_function">7.117. SIGN Function</a>
+<li><a href="#sha2_function">7.117. SHA2 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sign">7.117.1. Examples of SIGN</a></li>
+<li><a href="#examples_of_sha2">7.117.1. examples of SHA2</a></li>
</ul>
</li>
-<li><a href="#sin_function">7.118. SIN Function</a>
+<li><a href="#sign_function">7.118. SIGN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sin">7.118.1. Examples of SIN</a></li>
+<li><a href="#examples_of_sign">7.118.1. Examples of SIGN</a></li>
</ul>
</li>
-<li><a href="#sinh_function">7.119. SINH Function</a>
+<li><a href="#sin_function">7.119. SIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sinh">7.119.1. Examples of SINH</a></li>
-<li><a href="#space_function">7.119.2. SPACE Function</a></li>
-<li><a href="#examples_of_space">7.119.3. Examples of SPACE</a></li>
+<li><a href="#examples_of_sin">7.119.1. Examples of SIN</a></li>
</ul>
</li>
-<li><a href="#sqrt_function">7.120. SQRT Function</a>
+<li><a href="#sinh_function">7.120. SINH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sqrt">7.120.1. Examples of SQRT</a></li>
+<li><a href="#examples_of_sinh">7.120.1. Examples of SINH</a></li>
+<li><a href="#space_function">7.120.2. SPACE Function</a></li>
+<li><a href="#examples_of_space">7.120.3. Examples of SPACE</a></li>
</ul>
</li>
-<li><a href="#stddev_function">7.121. STDDEV Function</a>
+<li><a href="#sqrt_function">7.121. SQRT Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_stddev">7.121.1. Considerations for STDDEV</a></li>
-<li><a href="#examples_of_stddev">7.121.2. Examples of STDDEV</a></li>
+<li><a href="#examples_of_sqrt">7.121.1. Examples of SQRT</a></li>
</ul>
</li>
-<li><a href="#stringtolob_function">7.122. STRINGTOLOB Function</a>
+<li><a href="#stddev_function">7.122. STDDEV Function</a>
<ul class="sectlevel3">
-<li><a href="#stringtolob_function_syntax">7.122.1. Syntax Descriptions of STRINGTOLOB Function</a></li>
-<li><a href="#stringtolob_function_examples">7.122.2. Examples of STRINGTOLOB Function</a></li>
+<li><a href="#considerations_for_stddev">7.122.1. Considerations for STDDEV</a></li>
+<li><a href="#examples_of_stddev">7.122.2. Examples of STDDEV</a></li>
</ul>
</li>
-<li><a href="#substring_function">7.123. SUBSTRING/SUBSTR Function</a>
+<li><a href="#stringtolob_function">7.123. STRINGTOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#alternative_forms">7.123.1. Alternative Forms</a></li>
-<li><a href="#considerations_for_substring">7.123.2. Considerations for SUBSTRING/SUBSTR</a></li>
-<li><a href="#examples_of_substring">7.123.3. Examples of SUBSTRING/SUBSTR</a></li>
+<li><a href="#stringtolob_function_syntax">7.123.1. Syntax Descriptions of STRINGTOLOB Function</a></li>
+<li><a href="#stringtolob_function_examples">7.123.2. Examples of STRINGTOLOB Function</a></li>
</ul>
</li>
-<li><a href="#sum_function">7.124. SUM Function</a>
+<li><a href="#substring_function">7.124. SUBSTRING/SUBSTR Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_sum">7.124.1. Considerations for SUM</a></li>
-<li><a href="#examples_of_sum">7.124.2. Examples of SUM</a></li>
+<li><a href="#alternative_forms">7.124.1. Alternative Forms</a></li>
+<li><a href="#considerations_for_substring">7.124.2. Considerations for SUBSTRING/SUBSTR</a></li>
+<li><a href="#examples_of_substring">7.124.3. Examples of SUBSTRING/SUBSTR</a></li>
</ul>
</li>
-<li><a href="#sysdate_function">7.125. SYSDATE Function</a>
+<li><a href="#sum_function">7.125. SUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sysdate">7.125.1. Examples of SYSDATE</a></li>
+<li><a href="#considerations_for_sum">7.125.1. Considerations for SUM</a></li>
+<li><a href="#examples_of_sum">7.125.2. Examples of SUM</a></li>
</ul>
</li>
-<li><a href="#systimestamp_function">7.126. SYSTIMESTAMP Function</a>
+<li><a href="#sysdate_function">7.126. SYSDATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_systimestamp">7.126.1. Examples of SYSTIMESTAMP</a></li>
+<li><a href="#examples_of_sysdate">7.126.1. Examples of SYSDATE</a></li>
</ul>
</li>
-<li><a href="#tan_function">7.127. TAN Function</a>
+<li><a href="#systimestamp_function">7.127. SYSTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_tan">7.127.1. Examples of TAN</a></li>
-<li><a href="#tanh_function">7.127.2. TANH Function</a></li>
-<li><a href="#examples_of_tanh">7.127.3. Examples of TANH</a></li>
+<li><a href="#examples_of_systimestamp">7.127.1. Examples of SYSTIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#this_function">7.128. THIS Function</a>
+<li><a href="#tan_function">7.128. TAN Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_this">7.128.1. Considerations for THIS</a></li>
-<li><a href="#examples_of_this">7.128.2. Examples of THIS</a></li>
+<li><a href="#examples_of_tan">7.128.1. Examples of TAN</a></li>
+<li><a href="#tanh_function">7.128.2. TANH Function</a></li>
+<li><a href="#examples_of_tanh">7.128.3. Examples of TANH</a></li>
</ul>
</li>
-<li><a href="#timestampadd_function">7.129. TIMESTAMPADD Function</a>
+<li><a href="#this_function">7.129. THIS Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampadd">7.129.1. Examples of TIMESTAMPADD</a></li>
+<li><a href="#considerations_for_this">7.129.1. Considerations for THIS</a></li>
+<li><a href="#examples_of_this">7.129.2. Examples of THIS</a></li>
</ul>
</li>
-<li><a href="#timestampdiff_function">7.130. TIMESTAMPDIFF Function</a>
+<li><a href="#timestampadd_function">7.130. TIMESTAMPADD Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampdiff">7.130.1. Examples of TIMESTAMPDIFF</a></li>
+<li><a href="#examples_of_timestampadd">7.130.1. Examples of TIMESTAMPADD</a></li>
</ul>
</li>
-<li><a href="#to_char_function">7.131. TO_CHAR Function</a>
+<li><a href="#timestampdiff_function">7.131. TIMESTAMPDIFF Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_char">7.131.1. Considerations for TO_CHAR</a></li>
-<li><a href="#examples_of_to_char">7.131.2. Examples of TO_CHAR</a></li>
+<li><a href="#examples_of_timestampdiff">7.131.1. Examples of TIMESTAMPDIFF</a></li>
</ul>
</li>
-<li><a href="#to_date_function">7.132. TO_DATE Function</a>
+<li><a href="#to_char_function">7.132. TO_CHAR Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_date">7.132.1. Considerations for TO_DATE</a></li>
-<li><a href="#examples_of_to_date">7.132.2. Examples of TO_DATE</a></li>
+<li><a href="#considerations_for_to_char">7.132.1. Considerations for TO_CHAR</a></li>
+<li><a href="#examples_of_to_char">7.132.2. Examples of TO_CHAR</a></li>
</ul>
</li>
-<li><a href="#to_time_function">7.133. TO_TIME Function</a>
+<li><a href="#to_date_function">7.133. TO_DATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_time">7.133.1. Examples of TO_TIME</a></li>
+<li><a href="#considerations_for_to_date">7.133.1. Considerations for TO_DATE</a></li>
+<li><a href="#examples_of_to_date">7.133.2. Examples of TO_DATE</a></li>
</ul>
</li>
-<li><a href="#to_timestamp_function">7.134. TO_TIMESTAMP Function</a>
+<li><a href="#to_time_function">7.134. TO_TIME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_timestamp">7.134.1. Example of TO_TIMESTAMP</a></li>
+<li><a href="#examples_of_to_time">7.134.1. Examples of TO_TIME</a></li>
</ul>
</li>
-<li><a href="#translate_function">7.135. TRANSLATE Function</a></li>
-<li><a href="#trim_function">7.136. TRIM Function</a>
+<li><a href="#to_timestamp_function">7.135. TO_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_trim">7.136.1. Considerations for TRIM</a></li>
-<li><a href="#examples_of_trim">7.136.2. Examples of TRIM</a></li>
+<li><a href="#examples_of_to_timestamp">7.135.1. Example of TO_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#ucase_function">7.137. UCASE Function</a>
+<li><a href="#translate_function">7.136. TRANSLATE Function</a></li>
+<li><a href="#trim_function">7.137. TRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_ucase">7.137.1. Considerations for UCASE</a></li>
-<li><a href="#examples_of_ucase">7.137.2. Examples of UCASE</a></li>
-<li><a href="#upper_function">7.137.3. UPPER Function</a></li>
-<li><a href="#examples_of_upper">7.137.4. Examples of UPPER</a></li>
-<li><a href="#upshift_function">7.137.5. UPSHIFT Function</a></li>
-<li><a href="#examples_of_upshift">7.137.6. Examples of UPSHIFT</a></li>
+<li><a href="#considerations_for_trim">7.137.1. Considerations for TRIM</a></li>
+<li><a href="#examples_of_trim">7.137.2. Examples of TRIM</a></li>
</ul>
</li>
-<li><a href="#rand_function">7.138. RAND Function</a>
+<li><a href="#ucase_function">7.138. UCASE Function</a>
<ul class="sectlevel3">
-<li><a href="#rand_function_syntax">7.138.1. Syntax Descriptions of RAND Function</a></li>
-<li><a href="#rand_function_considerations">7.138.2. Considerations for RAND Function</a></li>
-<li><a href="#rand_function_example">7.138.3. Examples of RAND Function</a></li>
+<li><a href="#considerations_for_ucase">7.138.1. Considerations for UCASE</a></li>
+<li><a href="#examples_of_ucase">7.138.2. Examples of UCASE</a></li>
+<li><a href="#upper_function">7.138.3. UPPER Function</a></li>
+<li><a href="#examples_of_upper">7.138.4. Examples of UPPER</a></li>
+<li><a href="#upshift_function">7.138.5. UPSHIFT Function</a></li>
+<li><a href="#examples_of_upshift">7.138.6. Examples of UPSHIFT</a></li>
</ul>
</li>
-<li><a href="#user_function">7.139. USER Function</a>
+<li><a href="#rand_function">7.139. RAND Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_user">7.139.1. Considerations for USER</a></li>
-<li><a href="#examples_of_user">7.139.2. Examples of USER</a></li>
+<li><a href="#rand_function_syntax">7.139.1. Syntax Descriptions of RAND Function</a></li>
+<li><a href="#rand_function_considerations">7.139.2. Considerations for RAND Function</a></li>
+<li><a href="#rand_function_example">7.139.3. Examples of RAND Function</a></li>
</ul>
</li>
-<li><a href="#variance_function">7.140. VARIANCE Function</a>
+<li><a href="#user_function">7.140. USER Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_variance">7.140.1. Considerations for VARIANCE</a></li>
-<li><a href="#examples_of_variance">7.140.2. Examples of VARIANCE</a></li>
+<li><a href="#considerations_for_user">7.140.1. Considerations for USER</a></li>
+<li><a href="#examples_of_user">7.140.2. Examples of USER</a></li>
</ul>
</li>
-<li><a href="#week_function">7.141. WEEK Function</a>
+<li><a href="#variance_function">7.141. VARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_week">7.141.1. Examples of WEEK</a></li>
+<li><a href="#considerations_for_variance">7.141.1. Considerations for VARIANCE</a></li>
+<li><a href="#examples_of_variance">7.141.2. Examples of VARIANCE</a></li>
</ul>
</li>
-<li><a href="#year_function">7.142. YEAR Function</a>
+<li><a href="#week_function">7.142. WEEK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_year">7.142.1. Examples of YEAR</a></li>
+<li><a href="#examples_of_week">7.142.1. Examples of WEEK</a></li>
</ul>
</li>
-<li><a href="#zeroifnull_function">7.143. ZEROIFNULL Function</a>
+<li><a href="#year_function">7.143. YEAR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_zeroifnull">7.143.1. Examples of ZEROIFNULL</a></li>
+<li><a href="#examples_of_year">7.143.1. Examples of YEAR</a></li>
+</ul>
+</li>
+<li><a href="#zeroifnull_function">7.144. ZEROIFNULL Function</a>
+<ul class="sectlevel3">
+<li><a href="#examples_of_zeroifnull">7.144.1. Examples of ZEROIFNULL</a></li>
</ul>
</li>
</ul>
@@ -4125,6 +4127,10 @@ To run this statement, AUTOCOMMIT must be turned ON (the default) for the sessio
alter-action is:
ADD [IF NOT EXISTS][COLUMN] column-definition
| ADD [CONSTRAINT constraint-name] table-constraint
+ | ENABLE ALL [UNIQUE] INDEXES
+ | ENABLE INDEX index-name
+ | DISABLE ALL [UNIQUE] INDEXES
+ | DISABLE INDEX index-name
| DROP CONSTRAINT constraint-name [RESTRICT]
| RENAME TO new-name
| DROP COLUMN [IF EXISTS] column-name
@@ -4409,6 +4415,71 @@ the foreign key clause. for information about <em>ref-spec</em>, see references
<div class="ulist">
<ul>
<li>
+<p>ENABLE ALL [UNIQUE] INDEXES</p>
+<div class="ulist">
+<ul>
+<li>
+<p>ENABLE ALL UNIQUE INDEXES</p>
+<div class="paragraph">
+<p>enables all unique indexes on the table.</p>
+</div>
+</li>
+<li>
+<p>ENABLE ALL INDEXES</p>
+<div class="paragraph">
+<p>enables all indexes (including both non-unique and unique indexes) on the table.</p>
+</div>
+</li>
+</ul>
+</div>
+</li>
+<li>
+<p><em>index-name</em></p>
+<div class="paragraph">
+<p>is an SQL identifier that specifies the simple name for the index. You cannot qualify index-name with its schema name.
+Indexes have their own name space within a schema,
+so an index name might be the same as a table or constraint name. However, no two indexes in a schema can have the same name.</p>
+</div>
+</li>
+<li>
+<p>ENABLE INDEX <em>index-name</em></p>
+<div class="paragraph">
+<p>enables an index on the table.</p>
+</div>
+</li>
+<li>
+<p>DISABLE ALL [UNIQUE] INDEXES</p>
+<div class="ulist">
+<ul>
+<li>
+<p>DISABLE ALL UNIQUE INDEXES</p>
+<div class="paragraph">
+<p>disables all unique indexes on the table.</p>
+</div>
+</li>
+<li>
+<p>DISABLE ALL INDEXES</p>
+<div class="paragraph">
+<p>disables all indexes (including both non-unique and unique indexes) on the table.</p>
+</div>
+</li>
+</ul>
+</div>
+</li>
+<li>
+<p>DISABLE INDEX <em>index-name</em></p>
+<div class="paragraph">
+<p>disables an index on the table.
+The index still exists in the data, but it will not
+be chosen by the optimizer as an access path.</p>
+</div>
+</li>
+</ul>
+</div>
+<div style="page-break-after: always;"></div>
+<div class="ulist">
+<ul>
+<li>
<p><code>drop constraint <em>constraint-name</em> [restrict]</code></p>
<div class="paragraph">
<p>drops a constraint from the table.<br></p>
@@ -4632,6 +4703,223 @@ ALTER COLUMN vend_id RENAME TO cstm_id;</code></pre>
</div>
</div>
</li>
+<li>
+<p>The following table <em>orders</em> has two non-unique indexes
+(<em>index_orders1</em> and <em>index_orders2</em>) and
+two unique indexes (<em>unique_index_orders1</em> and <em>unique_index_orders2</em>).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ ORDER_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ SALESREP ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Disable one unique index (<em>unique_index_orders1</em>) and verify that all non-unique indexes (<em>index_orders1</em> and <em>index_orders2</em>)
+and the rest unique index (<em>unique_index_orders2</em>) are still enabled.</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL>ALTER TABLE ORDERS DISABLE INDEX unique_index_orders1;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ ORDER_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Disable one non-unique index (<em>index_orders1</em>) and verify that the rest non-unique index (<em>index_orders2</em>)
+and the rest unique index (<em>unique_index_orders2</em>) are still enabled.</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL>ALTER TABLE ORDERS DISABLE INDEX index_orders1;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Disable all indexes and verify that all of them (including both non-unique and unique indexes) are disabled.</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL>ALTER TABLE ORDERS DISABLE ALL INDEXES;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Enable all indexes and verify the result.</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL>ALTER TABLE orders ENABLE ALL INDEXES;
+--- SQL operation complete.
+
+SQL>SHOWDDL orders;
+CREATE TABLE TRAFODION.SEABASE.ORDERS
+ (
+ ORDERNUM NUMERIC(6, 0) DEFAULT NULL NOT SERIALIZED
+ , ORDER_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , DELIV_DATE DATE DEFAULT NULL NOT SERIALIZED
+ , SALESREP NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ , CUSTNUM NUMERIC(4, 0) DEFAULT NULL NOT SERIALIZED
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ ORDER_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE INDEX INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ DELIV_DATE ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS1 ON TRAFODION.SEABASE.ORDERS
+ (
+ SALESREP ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+CREATE UNIQUE INDEX UNIQUE_INDEX_ORDERS2 ON TRAFODION.SEABASE.ORDERS
+ (
+ CUSTNUM ASC
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.ORDERS TO DB__ROOT WITH GRANT OPTION;
+
+--- SQL operation complete.</code></pre>
+</div>
+</div>
+</li>
</ul>
</div>
<div style="page-break-after: always;"></div>
@@ -11851,7 +12139,7 @@ to running a list command from an HBase shell, but without having to start and c
</div>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">GET [ USER | SYSTEM | EXTERNAL | ALL } HBASE OBJECTS</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">GET { USER | SYSTEM | EXTERNAL | ALL } HBASE OBJECTS</code></pre>
</div>
</div>
<div class="sect3">
@@ -33762,9 +34050,8 @@ FROM DUAL;</code></pre>
</ul>
</div>
</div>
-</div>
-<div class="sect3">
-<h4 id="date_difference_in_year">7.40.4. Date Difference in YEAR</h4>
+<div class="sect4">
+<h5 id="date_difference_in_year">Date Difference in YEAR</h5>
<div class="ulist">
<ul>
<li>
@@ -33796,8 +34083,10 @@ FROM DUAL;</code></pre>
</div>
<div style="page-break-after: always;"></div>
</div>
-<div class="sect3">
-<h4 id="dateformat_function">7.40.5. DATEFORMAT Function</h4>
+</div>
+</div>
+<div class="sect2">
+<h3 id="dateformat_function">7.41. DATEFORMAT Function</h3>
<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
@@ -33828,16 +34117,15 @@ or TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressio
</li>
</ul>
</div>
-</div>
<div class="sect3">
-<h4 id="considerations_for_dateformat">7.40.6. Considerations for DATEFORMAT</h4>
+<h4 id="considerations_for_dateformat">7.41.1. 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.40.7. Examples of DATEFORMAT</h4>
+<h4 id="examples_of_dateformat">7.41.2. Examples of DATEFORMAT</h4>
<div class="ulist">
<ul>
<li>
@@ -33866,7 +34154,7 @@ function returns this string literal:</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_part_function_of_an_interval">7.41. DATE_PART Function (of an Interval)</h3>
+<h3 id="date_part_function_of_an_interval">7.42. 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
@@ -33911,7 +34199,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.41.1. Examples of DATE_PART</h4>
+<h4 id="examples_of_date_part">7.42.1. Examples of DATE_PART</h4>
<div class="ulist">
<ul>
<li>
@@ -33944,7 +34232,7 @@ quotes.</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_part_function_of_a_timestamp">7.42. DATE_PART Function (of a Timestamp)</h3>
+<h3 id="date_part_function_of_a_timestamp">7.43. 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
@@ -34010,7 +34298,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.42.1. Examples of DATE_PART</h4>
+<h4 id="examples_of_date_part">7.43.1. Examples of DATE_PART</h4>
<div class="ulist">
<ul>
<li>
@@ -34051,7 +34339,7 @@ and YEARWEEK text specification with EXTRACT.</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_trunc_function">7.43. DATE_TRUNC Function</h3>
+<h3 id="date_trunc_function">7.44. 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
@@ -34087,7 +34375,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.43.1. Examples of DATE_TRUNC</h4>
+<h4 id="examples_of_date_trunc">7.44.1. Examples of DATE_TRUNC</h4>
<div class="ulist">
<ul>
<li>
@@ -34133,7 +34421,7 @@ months or days). See <a href="#datetime_value_expressions">Datetime Value Expres
</div>
</div>
<div class="sect2">
-<h3 id="day_function">7.44. DAY Function</h3>
+<h3 id="day_function">7.45. 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
@@ -34160,7 +34448,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_day">7.44.1. Examples of Day</h4>
+<h4 id="examples_of_day">7.45.1. Examples of Day</h4>
<div class="ulist">
<ul>
<li>
@@ -34184,7 +34472,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayname_function">7.45. DAYNAME Function</h3>
+<h3 id="dayname_function">7.46. 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,
@@ -34210,13 +34498,13 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_dayname">7.45.1. Considerations for DAYNAME</h4>
+<h4 id="considerations_for_dayname">7.46.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.45.2. Examples of DAYNAME</h4>
+<h4 id="examples_of_dayname">7.46.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>
@@ -34236,7 +34524,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofmonth_function">7.46. DAYOFMONTH Function</h3>
+<h3 id="dayofmonth_function">7.47. DAYOFMONTH Function</h3>
<div class="paragraph">
<p>The DAYOFMONTH function converts a DATE or TIMESTAMP expression into an
INTEGER in the range 1 through 31 that represents the
@@ -34263,7 +34551,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofmonth">7.46.1. Examples of DAYOFMONTH</h4>
+<h4 id="examples_of_dayofmonth">7.47.1. Examples of DAYOFMONTH</h4>
<div class="ulist">
<ul>
<li>
@@ -34287,7 +34575,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofweek_function">7.47. DAYOFWEEK Function</h3>
+<h3 id="dayofweek_function">7.48. DAYOFWEEK Function</h3>
<div class="paragraph">
<p>The DAYOFWEEK function converts a DATE or TIMESTAMP expression into an
INTEGER in the range 1 through 7 that represents the corresponding
@@ -34314,7 +34602,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofweek">7.47.1. Examples of DAYOFWEEK</h4>
+<h4 id="examples_of_dayofweek">7.48.1. Examples of DAYOFWEEK</h4>
<div class="ulist">
<ul>
<li>
@@ -34341,7 +34629,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofyear_function">7.48. DAYOFYEAR Function</h3>
+<h3 id="dayofyear_function">7.49. DAYOFYEAR Function</h3>
<div class="paragraph">
<p>The DAYOFYEAR function converts a DATE or TIMESTAMP expression into an
INTEGER in the range 1 through 366 that represents the
@@ -34367,7 +34655,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofyear">7.48.1. Examples of DAYOFYEAR</h4>
+<h4 id="examples_of_dayofyear">7.49.1. Examples of DAYOFYEAR</h4>
<div class="ulist">
<ul>
<li>
@@ -34391,7 +34679,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="Decode_function">7.49. DECODE Function</h3>
+<h3 id="Decode_function">7.50. 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
@@ -34436,7 +34724,7 @@ returned.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_decode">7.49.1. Considerations for DECODE</h4>
+<h4 id="considerations_for_decode">7.50.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
@@ -34569,7 +34857,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.49.2. Examples of DECODE</h4>
+<h4 id="_examples_of_decode">7.50.2. Examples of DECODE</h4>
<div class="ulist">
<ul>
<li>
@@ -34636,7 +34924,7 @@ value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="degrees_function">7.50. DEGREES Function</h3>
+<h3 id="degrees_function">7.51. DEGREES Function</h3>
<div class="paragraph">
<p>The DEGREES function converts a numeric value expression expressed in
radians to the number of degrees.</p>
@@ -34662,7 +34950,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_degrees">7.50.1. Examples of Degrees</h4>
+<h4 id="examples_of_degrees">7.51.1. Examples of Degrees</h4>
<div class="ulist">
<ul>
<li>
@@ -34688,7 +34976,7 @@ inverse of the function radians.</p>
</div>
</div>
<div class="sect2">
-<h3 id="diff1_function">7.51. DIFF1 Function</h3>
+<h3 id="diff1_function">7.52. 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
@@ -34732,7 +35020,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.51.1. Considerations for DIFF1</h4>
+<h4 id="considerations_for_diff1">7.52.1. Considerations for DIFF1</h4>
<div class="sect4">
<h5 id="equivalent-result">Equivalent Result</h5>
<div class="paragraph">
@@ -34763,7 +35051,7 @@ division by a value of INTERVAL data type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_diff1">7.51.2. Examples of DIFF1</h4>
+<h4 id="examples_of_diff1">7.52.2. Examples of DIFF1</h4>
<div class="ulist">
<ul>
<li>
@@ -34853,7 +35141,7 @@ example, 0.0007319 is equal to 21959 divided by 30002620.</p>
</div>
</div>
<div class="sect2">
-<h3 id="diff2_function">7.52. DIFF2 Function</h3>
+<h3 id="diff2_function">7.53. 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
@@ -34893,7 +35181,7 @@ See <a href="#diff1_function">DIFF1 Function</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_diff2">7.52.1. Considerations for DIFF2</h4>
+<h4 id="considerations_for_diff2">7.53.1. Considerations for DIFF2</h4>
<div class="sect4">
<h5 id="equivalent_result_1">Equivalent Result</h5>
<div class="ulist">
@@ -34934,7 +35222,7 @@ division by a value of INTERVAL data type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_diff2">7.52.2. Examples of DIFF2</h4>
+<h4 id="examples_of_diff2">7.53.2. Examples of DIFF2</h4>
<div class="ulist">
<ul>
<li>
@@ -34992,9 +35280,9 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="emptyblob_function">7.53. EMPTY_BLOB() Function</h3>
+<h3 id="emptyblob_function">7.54. EMPTY_BLOB() Function</h3>
<div class="sect3">
-<h4 id="syntax_descriptions_of_emptyblob_function">7.53.1. Syntax Descriptions of EMPTY_BLOB() Function</h4>
+<h4 id="syntax_descriptions_of_emptyblob_function">7.54.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>
@@ -35014,7 +35302,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_emptyblob_function">7.53.2. Considerations for EMPTY_BLOB() Function</h4>
+<h4 id="considerations_for_emptyblob_function">7.54.2. Considerations for EMPTY_BLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35050,7 +35338,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_emptyblob_function">7.53.3. Examples of EMPTY_BLOB() Function</h4>
+<h4 id="examples_of_emptyblob_function">7.54.3. Examples of EMPTY_BLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35067,9 +35355,9 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="emptyclob_function">7.54. EMPTY_CLOB() Function</h3>
+<h3 id="emptyclob_function">7.55. EMPTY_CLOB() Function</h3>
<div class="sect3">
-<h4 id="syntax_descriptions_of_emptyclob_function">7.54.1. Syntax Descriptions of EMPTY_CLOB() Function</h4>
+<h4 id="syntax_descriptions_of_emptyclob_function">7.55.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>
@@ -35089,7 +35377,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_emptyclob_function">7.54.2. Considerations for EMPTY_CLOB() Function</h4>
+<h4 id="considerations_for_emptyclob_function">7.55.2. Considerations for EMPTY_CLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35115,7 +35403,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_emptyclob_function">7.54.3. Examples of EMPTY_CLOB() Function</h4>
+<h4 id="examples_of_emptyclob_function">7.55.3. Examples of EMPTY_CLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35132,7 +35420,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="exp_function">7.55. EXP Function</h3>
+<h3 id="exp_function">7.56. 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>
@@ -35162,7 +35450,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.55.1. Examples of EXP</h4>
+<h4 id="examples_of_exp">7.56.1. Examples of EXP</h4>
<div class="ulist">
<ul>
<li>
@@ -35189,7 +35477,7 @@ of the function LOG:</p>
</div>
</div>
<div class="sect2">
-<h3 id="explain_function">7.56. EXPLAIN Function</h3>
+<h3 id="explain_function">7.57. 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
@@ -35249,7 +35537,7 @@ name in a PREPARE statement.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_explain_function">7.56.1. Considerations for EXPLAIN Function</h4>
+<h4 id="considerations_for_explain_function">7.57.1. Considerations for EXPLAIN Function</h4>
<div class="sect4">
<h5 id="using_a_statement_pattern">Using a Statement Pattern</h5>
<div class="paragraph">
@@ -35489,7 +35777,7 @@ a nested-loop join.</p></td>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_explain_function">7.56.2. Examples of EXPLAIN Function</h4>
+<h4 id="examples_of_explain_function">7.57.2. Examples of EXPLAIN Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35521,9 +35809,9 @@ then selects the desired columns.</p>
</div>
</div>
<div class="sect2">
-<h3 id="externaltolob_function">7.57. EXTERNALTOLOB Function</h3>
+<h3 id="externaltolob_function">7.58. EXTERNALTOLOB Function</h3>
<div class="sect3">
-<h4 id="externaltolob_function_syntax">7.57.1. Syntax Descriptions of EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_syntax">7.58.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>
@@ -35546,7 +35834,7 @@ hdfs:///{local hdfs file name}</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="externaltolob_function_considerations">7.57.2. Considerations for EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_considerations">7.58.2. Considerations for EXTERNALTOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35559,7 +35847,7 @@ hdfs:///{local hdfs file name}</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="externaltolob_function_examples">7.57.3. Examples of EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_examples">7.58.3. Examples of EXTERNALTOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35586,7 +35874,7 @@ externaltolob('hdfs:///lobs/lob_input_a1.txt'));</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="extract_function">7.58. EXTRACT Function</h3>
+<h3 id="extract_function">7.59. 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>
@@ -35617,7 +35905,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.58.1. Examples of EXTRACT</h4>
+<h4 id="examples_of_extract">7.59.1. Examples of EXTRACT</h4>
<div class="ulist">
<ul>
<li>
@@ -35648,9 +35936,9 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="filetolob_function">7.59. FILETOLOB Function</h3>
+<h3 id="filetolob_function">7.60. FILETOLOB Function</h3>
<div class="sect3">
-<h4 id="filetolob_function_syntax">7.59.1. Syntax Descriptions of FILETOLOB Function</h4>
+<h4 id="filetolob_function_syntax">7.60.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>
@@ -35677,7 +35965,7 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect3">
-<h4 id="filetolob_function_examples">7.59.2. Examples of FILETOLOB Function</h4>
+<h4 id="filetolob_function_examples">7.60.2. Examples of FILETOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35702,7 +35990,7 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="group_concat_function">7.60. GROUP_CONCAT Function</h3>
+<h3 id="group_concat_function">7.61. 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.
@@ -35727,7 +36015,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.60.1. Examples of GROUP_CONCAT</h4>
+<h4 id="examples_of_group_concat">7.61.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>
@@ -35748,7 +36036,7 @@ tom 91 77 43</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="hour_function">7.61. HOUR Function</h3>
+<h3 id="hour_function">7.62. HOUR Function</h3>
<div class="paragraph">
<p>The HOUR function converts a TIME or TIMESTAMP expression into an
INTEGER in the range 0 through 23 that represents the
@@ -35774,7 +36062,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_hour">7.61.1. Examples of HOUR</h4>
+<h4 id="examples_of_hour">7.62.1. Examples of HOUR</h4>
<div class="ulist">
<ul>
<li>
@@ -35799,7 +36087,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="insert_function">7.62. INSERT Function</h3>
+<h3 id="insert_function">7.63. 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
@@ -35849,7 +36137,7 @@ or equal to the length of <em>char-expr-1</em>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_insert">7.62.1. Examples of INSERT</h4>
+<h4 id="examples_of_insert">7.63.1. Examples of INSERT</h4>
<div class="ulist">
<ul>
<li>
@@ -35883,7 +36171,7 @@ SALES REP
</div>
</div>
<div class="sect2">
-<h3 id="is_ipv4_function">7.63. IS_IPV4 Function</h3>
+<h3 id="is_ipv4_function">7.64. 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>
@@ -35906,7 +36194,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_is_ipv4">7.63.1. Examples of IS_IPV4</h4>
+<h4 id="examples_of_is_ipv4">7.64.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>
@@ -35924,7 +36212,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="is_ipv6_function">7.64. IS_IPV6 Function</h3>
+<h3 id="is_ipv6_function">7.65. 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>
@@ -35948,7 +36236,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_is_ipv6">7.64.1. Examples of IS_IPV6</h4>
+<h4 id="examples_of_is_ipv6">7.65.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>
@@ -35964,7 +36252,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="inet_aton_function">7.65. INET_ATON Function</h3>
+<h3 id="inet_aton_function">7.66. INET_ATON Function</h3>
<div class="paragraph">
<p>Given the dotted-quad representation of an IPv4 network address as a string,
returns an integer that represents the numeric value of the address in network
@@ -35989,7 +36277,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_inet_aton">7.65.1. Examples of INET_ATON</h4>
+<h4 id="examples_of_inet_aton">7.66.1. Examples of INET_ATON</h4>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">>>SELECT INET_ATON('10.0.5.9') from dual;
@@ -36003,7 +36291,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="inet_ntoa_function">7.66. INET_NTOA Function</h3>
+<h3 id="inet_ntoa_function">7.67. INET_NTOA Function</h3>
<div class="paragraph">
<p>Given a numeric IPv4 network address in network byte order, returns the
dotted-quad string representation of the address as a nonbinary string in
@@ -36030,7 +36318,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_inet_ntoa">7.66.1. Examples of INET_NTOA</h4>
+<h4 id="examples_of_inet_ntoa">7.67.1. Examples of INET_NTOA</h4>
<div class="paragraph">
<p>this function will convert an integer into the dotted-quad string
representation of the IP address.</p>
@@ -36047,7 +36335,7 @@ representation of the IP address.</p>
</div>
</div>
<div class="sect2">
-<h3 id="isnull_function">7.67. ISNULL Function</h3>
+<h3 id="isnull_function">7.68. ISNULL Function</h3>
<div class="paragraph">
<p>The ISNULL function returns the value of the first argument if it is not
null, otherwise it returns the value of the second argument. Both
@@ -36079,7 +36367,7 @@ with that of <em>ck-expr</em>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_isnull">7.67.1. Examples of ISNULL</h4>
+<h4 id="examples_of_isnull">7.68.1. Examples of ISNULL</h4>
<div class="ulist">
<ul>
<li>
@@ -36112,7 +36400,7 @@ with that of <em>ck-expr</em>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="juliantimestamp_function">7.68. JULIANTIMESTAMP Function</h3>
+<h3 id="juliantimestamp_function">7.69. JULIANTIMESTAMP Function</h3>
<div class="paragraph">
<p>The JULIANTIMESTAMP function converts a datetime value into a 64-bit
Julian timestamp value that represents the number of microseconds that
@@ -36148,14 +36436,14 @@ specified datetime value are set to zero. See
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_juliantimestamp">7.68.1. Considerations for JULIANTIMESTAMP</h4>
+<h4 id="considerations_for_juliantimestamp">7.69.1. Considerations for JULIANTIMESTAMP</h4>
<div class="paragraph">
<p>The <em>datetime-expression</em> value must be a date or timestamp value from
the beginning of year 0001 to the end of year 9999.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_juliantimestamp">7.68.2. Examples of JULIANTIMESTAMP</h4>
+<h4 id="examples_of_juliantimestamp">7.69.2. Examples of JULIANTIMESTAMP</h4>
<div class="paragraph">
<p>The project table consists of five columns using the data types NUMERIC,
VARCHAR, DATE, TIMESTAMP, and INTERVAL.</p>
@@ -36200,7 +36488,7 @@ START_DATE (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="lastnotnull_function">7.69. LASTNOTNULL Function</h3>
+<h3 id="lastnotnull_function">7.70. LASTNOTNULL Function</h3>
<div class="paragraph">
<p>The LASTNOTNULL function is a sequence function that returns the last
non-null value of a column in an intermediate result table ordered by a
@@ -36226,7 +36514,7 @@ expression. If only null values have been returned, LASTNOTNULL returns null.</p
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_lastnotnull">7.69.1. Examples of LASTNOTNULL</h4>
+<h4 id="examples_of_lastnotnull">7.70.1. Examples of LASTNOTNULL</h4>
<div class="ulist">
<ul>
<li>
@@ -36254,7 +36542,7 @@ lastnotnull
</div>
</div>
<div class="sect2">
-<h3 id="lcase_function">7.70. LCASE Function</h3>
+<h3 id="lcase_function">7.71. LCASE Function</h3>
<div class="paragraph">
<p>The LCASE function down-shifts alphanumeric characters. For
non-alphanumeric characters, LCASE returns the same character. LCASE can
@@ -36289,7 +36577,7 @@ characters to down-shift. See
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_lcase">7.70.1. Examples of LCASE</h4>
+<h4 id="examples_of_lcase">7.71.1. Examples of LCASE</h4>
<div class="ulist">
<ul>
<li>
@@ -36317,7 +36605,7 @@ Hotel Oregon HOTEL OREGON hotel oregon
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="left_function">7.70.2. LEFT Function</h4>
+<h4 id="left_function">7.71.2. LEFT Function</h4>
<div class="paragraph">
<p>The LEFT function returns the leftmost specified number of characters
from a character expression. Every character, including multi-byte
@@ -36354,7 +36642,7 @@ than or equal to 0 with a scale of zero.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_left">7.70.3. Examples of LEFT</h4>
+<h4 id="examples_of_left">7.71.3. Examples of LEFT</h4>
<div class="ulist">
<ul>
<li>
@@ -36397,7 +36685,7 @@ SECRETARY COMNET
</div>
</div>
<div class="sect2">
-<h3 id="locate_function">7.71. LOCATE Function</h3>
+<h3 id="locate_function">7.72. LOCATE Function</h3>
<div class="paragraph">
<p>The LOCATE function searches for a given substring in a character
string. If the substring is found, Trafodion SQL returns the character
@@ -36440,7 +36728,7 @@ of zero. If substring-expression is not found in source-expression , Trafodion
SQL returns 0.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_locate">7.71.1. Considerations for LOCATE</h4>
+<h4 id="considerations_for_locate">7.72.1. Considerations for LOCATE</h4>
<div class="sect4">
<h5 id="result_of_locate">Result of LOCATE</h5>
<div class="ulist">
@@ -36471,7 +36759,7 @@ function) for both the <em>substring-expression</em> and the <em>source-expressi
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_locate">7.71.2. Examples of LOCATE</h4>
+<h4 id="examples_of_locate">7.72.2. Examples of LOCATE</h4>
<div class="ulist">
<ul>
<li>
@@ -36500,7 +36788,7 @@ WHERE LOCATE ('SMITH',UCASE(empname)) > 0 ;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="log_function">7.72. LOG Function</h3>
+<h3 id="log_function">7.73. LOG Function</h3>
<div class="paragraph">
<p>The LOG function returns the natural logarithm of a numeric value
expression. LOG is a Trafodion SQL extension.</p>
@@ -36523,7 +36811,7 @@ than zero. See <a href="#numeric_value_expressions">Numeric Value Expressions</a
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_log">7.72.1. Examples of LOG</h4>
+<h4 id="examples_of_log">7.73.1. Examples of LOG</h4>
<div class="ulist">
<ul>
<li>
@@ -36540,7 +36828,7 @@ approximately 0.69315:</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="log10_function">7.72.2. LOG10 Function</h4>
+<h4 id="log10_function">7.73.2. LOG10 Function</h4>
<div class="paragraph">
<p>The LOG10 function returns the base 10 logarithm of a numeric value
expression.</p>
@@ -36568,7 +36856,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_log10">7.72.3. Examples of LOG10</h4>
+<h4 id="examples_of_log10">7.73.3. Examples of LOG10</h4>
<div class="ulist">
<ul>
<li>
@@ -36586,7 +36874,7 @@ approximately 1.3979:</p>
</div>
</div>
<div class="sect2">
-<h3 id="lower_function">7.73. LOWER Function</h3>
+<h3 id="lower_function">7.74. LOWER Function</h3>
<div class="paragraph">
<p>The LOWER function down-shifts alphanumeric characters. For
non-alphanumeric characters, LOWER returns the same character. LOWER can
@@ -36618,7 +36906,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_lower">7.73.1. Considerations for LOWER</h4>
+<h4 id="considerations_for_lower">7.74.1. Considerations for LOWER</h4>
<div class="paragraph">
<p>For a UTF8 character expression, the LOWER function down-shifts all the
uppercase or title case characters in a given string to lowercase and
@@ -36636,7 +36924,7 @@ and whose Unicode name includes <em>title</em>.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="examples_of_lower">7.73.2. Examples of LOWER</h4>
+<h4 id="examples_of_lower">7.74.2. Examples of LOWER</h4>
<div class="ulist">
<ul>
<li>
@@ -36665,7 +36953,7 @@ Hotel Oregon HOTEL OREGON hotel oregon
</div>
</div>
<div class="sect2">
-<h3 id="lpad_function">7.74. LPAD Function</h3>
+<h3 id="lpad_function">7.75. LPAD Function</h3>
<div class="paragraph">
<p>The LPAD function pads the left side of a string with the specified
string. Every character in the string, including multi-byte characters,
@@ -36706,7 +36994,7 @@ string size, the string is truncated.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_lpad">7.74.1. Examples of LPAD</h4>
+<h4 id="examples_of_lpad">7.75.1. Examples of LPAD</h4>
<div class="ulist">
<ul>
<li>
@@ -36755,7 +37043,7 @@ string size, the string is truncated.</p>
</div>
</div>
<div class="sect2">
-<h3 id="ltrim_function">7.75. LTRIM Function</h3>
+<h3 id="ltrim_function">7.76. LTRIM Function</h3>
<div class="paragraph">
<p>The LTRIM function removes leading spaces from a character string. If
you must remove any leading character other than space, use the TRIM
@@ -36782,7 +37070,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_ltrim">7.75.1. Considerations for LTRIM</h4>
+<h4 id="considerations_for_ltrim">7.76.1. Considerations for LTRIM</h4>
<div class="sect4">
<h5 id="result_of_ltrim">Result of LTRIM</h5>
<div class="paragraph">
@@ -36792,7 +37080,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_ltrim">7.75.2. Examples of LTRIM</h4>
+<h4 id="examples_of_ltrim">7.76.2. Examples of LTRIM</h4>
<div class="ulist">
<ul>
<li>
@@ -36812,7 +37100,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="max_function">7.76. MAX/MAXIMUM Function</h3>
+<h3 id="max_function">7.77. MAX/MAXIMUM Function</h3>
<div class="paragraph">
<p>MAX is an aggregate function that returns the maximum value within a set
of values. MAXIMUM is the equivalent of MAX wherever the function name
@@ -36852,11 +37140,11 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_max">7.76.1. Considerations for MAX/MAXIMUM</h4>
+<h4 id="considerations_for_max">7.77.1. Considerations for MAX/MAXIMUM</h4>
</div>
<div class="sect3">
-<h4 id="operands_of_the_expression">7.76.2. Operands of the Expression</h4>
+<h4 id="operands_of_the_expression">7.77.2. Operands of the Expression</h4>
<div class="paragraph">
<p>The expression includes columns from the rows of the SELECT result table
but cannot include an aggregate function. These expressions are valid:</p>
@@ -36870,7 +37158,7 @@ MAX (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_max">7.76.3. Examples of MAX/MAXIMUM</h4>
+<h4 id="examples_of_max">7.77.3. Examples of MAX/MAXIMUM</h4>
<div class="ulist">
<ul>
<li>
@@ -36893,7 +37181,7 @@ MAX (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="md5_function">7.77. MD5 Function</h3>
+<h3 id="md5_function">7.78. MD5 Function</h3>
<div class="paragraph">
<p>Calculates an MD5 128-bit checksum for the string. The value is returned
as a string of 32 hexadecimal digits, or NULL if the argument was NULL.</p>
@@ -36917,7 +37205,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_md5">7.77.1. Examples of MD5</h4>
+<h4 id="examples_of_md5">7.78.1. Examples of MD5</h4>
<div class="paragraph">
<p>The return value is a nonbinary string in the connection character set.</p>
</div>
@@ -36934,7 +37222,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="min_function">7.78. MIN Function</h3>
+<h3 id="min_function">7.79. MIN Function</h3>
<div class="paragraph">
<p>MIN is an aggregate function that returns the minimum value within a set
of values. The data type of the result is the same as the data type of
@@ -36972,7 +37260,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_min">7.78.1. Considerations for MIN</h4>
+<h4 id="considerations_for_min">7.79.1. Considerations for MIN</h4>
<div class="sect4">
<h5 id="operands_of_the_expression_3">Operands of the Expression</h5>
<div class="paragraph">
@@ -36991,7 +37279,7 @@ MIN (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_min">7.78.2. Examples of MIN</h4>
+<h4 id="examples_of_min">7.79.2. Examples of MIN</h4>
<div class="ulist">
<ul>
<li>
@@ -37014,7 +37302,7 @@ MIN (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="minute_function">7.79. MINUTE Funct
<TRUNCATED>