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/26 20:37:58 UTC
[02/26] trafodion-site git commit: Merge [TRAFODION-3030] PR 1527 Add
RAND function to SQL Reference Manual
http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/252a2ae7/docs/sql_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html
index e381a9f..7499eb8 100644
--- a/docs/sql_reference/index.html
+++ b/docs/sql_reference/index.html
@@ -1363,625 +1363,638 @@ table.CodeRay td.code>pre{padding:0}
<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_function">7.31. CURRENT Function</a>
+<li><a href="#count_function">7.31. COUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current">7.31.1. Examples of CURRENT</a></li>
+<li><a href="#considerations_for_count">7.31.1. Considerations for COUNT</a></li>
+<li><a href="#examples_of_count">7.31.2. Examples of COUNT</a></li>
+<li><a href="#examples_of_crc32">7.31.3. examples of CR32</a></li>
</ul>
</li>
-<li><a href="#current_date_function">7.32. CURRENT_DATE Function</a>
+<li><a href="#current_function">7.32. CURRENT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current_date">7.32.1. Examples of CURRENT_DATE</a></li>
+<li><a href="#examples_of_current">7.32.1. Examples of CURRENT</a></li>
</ul>
</li>
-<li><a href="#current_time_function">7.33. CURRENT_TIME Function</a>
+<li><a href="#current_date_function">7.33. CURRENT_DATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current_time">7.33.1. Examples of CURRENT_TIME</a></li>
+<li><a href="#examples_of_current_date">7.33.1. Examples of CURRENT_DATE</a></li>
</ul>
</li>
-<li><a href="#current_timestamp_function">7.34. CURRENT_TIMESTAMP Function</a>
+<li><a href="#current_time_function">7.34. CURRENT_TIME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_current_timestamp">7.34.1. Examples of CURRENT_TIMESTAMP</a></li>
+<li><a href="#examples_of_current_time">7.34.1. Examples of CURRENT_TIME</a></li>
</ul>
</li>
-<li><a href="#current_user_function">7.35. CURRENT_USER Function</a>
+<li><a href="#current_timestamp_function">7.35. CURRENT_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_current_timestamp">7.35.1. Examples of CURRENT_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#date_add_function">7.36. DATE_ADD Function</a>
+<li><a href="#current_user_function">7.36. CURRENT_USER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_add">7.36.1. Examples of DATE_ADD</a></li>
+<li><a href="#considerations_for_current_user">7.36.1. Considerations for CURRENT_USER</a></li>
+<li><a href="#examples_of_current_user">7.36.2. Examples of CURRENT_USER</a></li>
</ul>
</li>
-<li><a href="#date_sub_function">7.37. DATE_SUB Function</a>
+<li><a href="#date_add_function">7.37. DATE_ADD Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_sub">7.37.1. Examples of DATE_SUB</a></li>
+<li><a href="#examples_of_date_add">7.37.1. Examples of DATE_ADD</a></li>
</ul>
</li>
-<li><a href="#dateadd_function">7.38. DATEADD Function</a>
+<li><a href="#date_sub_function">7.38. DATE_SUB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dateadd">7.38.1. Examples of DATEADD</a></li>
+<li><a href="#examples_of_date_sub">7.38.1. Examples of DATE_SUB</a></li>
</ul>
</li>
-<li><a href="#datediff_function">7.39. DATEDIFF Function</a>
+<li><a href="#dateadd_function">7.39. DATEADD Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_dateadd">7.39.1. Examples of DATEADD</a></li>
</ul>
</li>
-<li><a href="#date_part_function_of_an_interval">7.40. DATE_PART Function (of an Interval)</a>
+<li><a href="#datediff_function">7.40. DATEDIFF Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_part">7.40.1. Examples of DATE_PART</a></li>
+<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_a_timestamp">7.41. DATE_PART Function (of a Timestamp)</a>
+<li><a href="#date_part_function_of_an_interval">7.41. DATE_PART Function (of an Interval)</a>
<ul class="sectlevel3">
<li><a href="#examples_of_date_part">7.41.1. Examples of DATE_PART</a></li>
</ul>
</li>
-<li><a href="#date_trunc_function">7.42. DATE_TRUNC Function</a>
+<li><a href="#date_part_function_of_a_timestamp">7.42. DATE_PART Function (of a Timestamp)</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_date_trunc">7.42.1. Examples of DATE_TRUNC</a></li>
+<li><a href="#examples_of_date_part">7.42.1. Examples of DATE_PART</a></li>
</ul>
</li>
-<li><a href="#day_function">7.43. DAY Function</a>
+<li><a href="#date_trunc_function">7.43. DATE_TRUNC Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_day">7.43.1. Examples of Day</a></li>
+<li><a href="#examples_of_date_trunc">7.43.1. Examples of DATE_TRUNC</a></li>
</ul>
</li>
-<li><a href="#dayname_function">7.44. DAYNAME Function</a>
+<li><a href="#day_function">7.44. DAY Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_day">7.44.1. Examples of Day</a></li>
</ul>
</li>
-<li><a href="#dayofmonth_function">7.45. DAYOFMONTH Function</a>
+<li><a href="#dayname_function">7.45. DAYNAME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofmonth">7.45.1. Examples of DAYOFMONTH</a></li>
+<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>
</ul>
</li>
-<li><a href="#dayofweek_function">7.46. DAYOFWEEK Function</a>
+<li><a href="#dayofmonth_function">7.46. DAYOFMONTH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofweek">7.46.1. Examples of DAYOFWEEK</a></li>
+<li><a href="#examples_of_dayofmonth">7.46.1. Examples of DAYOFMONTH</a></li>
</ul>
</li>
-<li><a href="#dayofyear_function">7.47. DAYOFYEAR Function</a>
+<li><a href="#dayofweek_function">7.47. DAYOFWEEK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_dayofyear">7.47.1. Examples of DAYOFYEAR</a></li>
+<li><a href="#examples_of_dayofweek">7.47.1. Examples of DAYOFWEEK</a></li>
</ul>
</li>
-<li><a href="#Decode_function">7.48. DECODE Function</a>
+<li><a href="#dayofyear_function">7.48. DAYOFYEAR Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_dayofyear">7.48.1. Examples of DAYOFYEAR</a></li>
</ul>
</li>
-<li><a href="#degrees_function">7.49. DEGREES Function</a>
+<li><a href="#Decode_function">7.49. DECODE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_degrees">7.49.1. Examples of Degrees</a></li>
+<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>
</ul>
</li>
-<li><a href="#diff1_function">7.50. DIFF1 Function</a>
+<li><a href="#degrees_function">7.50. DEGREES Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_degrees">7.50.1. Examples of Degrees</a></li>
</ul>
</li>
-<li><a href="#diff2_function">7.51. DIFF2 Function</a>
+<li><a href="#diff1_function">7.51. DIFF1 Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#emptyblob_function">7.52. EMPTY_BLOB() Function</a>
+<li><a href="#diff2_function">7.52. DIFF2 Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#emptyclob_function">7.53. EMPTY_CLOB() Function</a>
+<li><a href="#emptyblob_function">7.53. EMPTY_BLOB() Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#exp_function">7.54. EXP Function</a>
+<li><a href="#emptyclob_function">7.54. EMPTY_CLOB() Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_exp">7.54.1. Examples of EXP</a></li>
+<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>
</ul>
</li>
-<li><a href="#explain_function">7.55. EXPLAIN Function</a>
+<li><a href="#exp_function">7.55. EXP Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_exp">7.55.1. Examples of EXP</a></li>
</ul>
</li>
-<li><a href="#externaltolob_function">7.56. EXTERNALTOLOB Function</a>
+<li><a href="#explain_function">7.56. EXPLAIN Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#extract_function">7.57. EXTRACT Function</a>
+<li><a href="#externaltolob_function">7.57. EXTERNALTOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_extract">7.57.1. Examples of EXTRACT</a></li>
+<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>
</ul>
</li>
-<li><a href="#filetolob_function">7.58. FILETOLOB Function</a>
+<li><a href="#extract_function">7.58. EXTRACT Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_extract">7.58.1. Examples of EXTRACT</a></li>
</ul>
</li>
-<li><a href="#group_concat_function">7.59. GROUP_CONCAT Function</a>
+<li><a href="#filetolob_function">7.59. FILETOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_group_concat">7.59.1. Examples of GROUP_CONCAT</a></li>
+<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>
</ul>
</li>
-<li><a href="#hour_function">7.60. HOUR Function</a>
+<li><a href="#group_concat_function">7.60. GROUP_CONCAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_hour">7.60.1. Examples of HOUR</a></li>
+<li><a href="#examples_of_group_concat">7.60.1. Examples of GROUP_CONCAT</a></li>
</ul>
</li>
-<li><a href="#insert_function">7.61. INSERT Function</a>
+<li><a href="#hour_function">7.61. HOUR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_insert">7.61.1. Examples of INSERT</a></li>
+<li><a href="#examples_of_hour">7.61.1. Examples of HOUR</a></li>
</ul>
</li>
-<li><a href="#is_ipv4_function">7.62. IS_IPV4 Function</a>
+<li><a href="#insert_function">7.62. INSERT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_is_ipv4">7.62.1. Examples of IS_IPV4</a></li>
+<li><a href="#examples_of_insert">7.62.1. Examples of INSERT</a></li>
</ul>
</li>
-<li><a href="#is_ipv6_function">7.63. IS_IPV6 Function</a>
+<li><a href="#is_ipv4_function">7.63. IS_IPV4 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_is_ipv6">7.63.1. Examples of IS_IPV6</a></li>
+<li><a href="#examples_of_is_ipv4">7.63.1. Examples of IS_IPV4</a></li>
</ul>
</li>
-<li><a href="#inet_aton_function">7.64. INET_ATON Function</a>
+<li><a href="#is_ipv6_function">7.64. IS_IPV6 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_inet_aton">7.64.1. Examples of INET_ATON</a></li>
+<li><a href="#examples_of_is_ipv6">7.64.1. Examples of IS_IPV6</a></li>
</ul>
</li>
-<li><a href="#inet_ntoa_function">7.65. INET_NTOA Function</a>
+<li><a href="#inet_aton_function">7.65. INET_ATON Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_inet_ntoa">7.65.1. Examples of INET_NTOA</a></li>
+<li><a href="#examples_of_inet_aton">7.65.1. Examples of INET_ATON</a></li>
</ul>
</li>
-<li><a href="#isnull_function">7.66. ISNULL Function</a>
+<li><a href="#inet_ntoa_function">7.66. INET_NTOA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_isnull">7.66.1. Examples of ISNULL</a></li>
+<li><a href="#examples_of_inet_ntoa">7.66.1. Examples of INET_NTOA</a></li>
</ul>
</li>
-<li><a href="#juliantimestamp_function">7.67. JULIANTIMESTAMP Function</a>
+<li><a href="#isnull_function">7.67. ISNULL Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_isnull">7.67.1. Examples of ISNULL</a></li>
</ul>
</li>
-<li><a href="#lastnotnull_function">7.68. LASTNOTNULL Function</a>
+<li><a href="#juliantimestamp_function">7.68. JULIANTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_lastnotnull">7.68.1. Examples of LASTNOTNULL</a></li>
+<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>
</ul>
</li>
-<li><a href="#lcase_function">7.69. LCASE Function</a>
+<li><a href="#lastnotnull_function">7.69. LASTNOTNULL Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_lastnotnull">7.69.1. Examples of LASTNOTNULL</a></li>
</ul>
</li>
-<li><a href="#locate_function">7.70. LOCATE Function</a>
+<li><a href="#lcase_function">7.70. LCASE Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#log_function">7.71. LOG Function</a>
+<li><a href="#locate_function">7.71. LOCATE Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#lower_function">7.72. LOWER Function</a>
+<li><a href="#log_function">7.72. LOG Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#ltrim_function">7.73. LTRIM Function</a>
+<li><a href="#lower_function">7.73. LOWER Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#max_function">7.74. MAX/MAXIMUM Function</a>
+<li><a href="#lpad_function">7.74. LPAD Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_lpad">7.74.1. Examples of LPAD</a></li>
</ul>
</li>
-<li><a href="#md5_function">7.75. MD5 Function</a>
+<li><a href="#ltrim_function">7.75. LTRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_md5">7.75.1. Examples of MD5</a></li>
+<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>
</ul>
</li>
-<li><a href="#min_function">7.76. MIN Function</a>
+<li><a href="#max_function">7.76. MAX/MAXIMUM Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#minute_function">7.77. MINUTE Function</a>
+<li><a href="#md5_function">7.77. MD5 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_minute">7.77.1. Examples of minute</a></li>
+<li><a href="#examples_of_md5">7.77.1. Examples of MD5</a></li>
</ul>
</li>
-<li><a href="#mod_function">7.78. MOD Function</a>
+<li><a href="#min_function">7.78. MIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_mod">7.78.1. Examples of MOD</a></li>
+<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>
</ul>
</li>
-<li><a href="#month_function">7.79. MONTH Function</a>
+<li><a href="#minute_function">7.79. MINUTE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_month">7.79.1. Examples of MONTH</a></li>
+<li><a href="#examples_of_minute">7.79.1. Examples of minute</a></li>
</ul>
</li>
-<li><a href="#monthname_function">7.80. MONTHNAME Function</a>
+<li><a href="#mod_function">7.80. MOD Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_mod">7.80.1. Examples of MOD</a></li>
</ul>
</li>
-<li><a href="#movingavg_function">7.81. MOVINGAVG Function</a>
+<li><a href="#month_function">7.81. MONTH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingavg">7.81.1. Examples of MOVINGAVG</a></li>
+<li><a href="#examples_of_month">7.81.1. Examples of MONTH</a></li>
</ul>
</li>
-<li><a href="#movingcount_function">7.82. MOVINGCOUNT Function</a>
+<li><a href="#monthname_function">7.82. MONTHNAME Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#movingmax_function">7.83. MOVINGMAX Function</a>
+<li><a href="#movingavg_function">7.83. MOVINGAVG Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingmax">7.83.1. Examples of MOVINGMAX</a></li>
+<li><a href="#examples_of_movingavg">7.83.1. Examples of MOVINGAVG</a></li>
</ul>
</li>
-<li><a href="#movingmin_function">7.84. MOVINGMIN Function</a>
+<li><a href="#movingcount_function">7.84. MOVINGCOUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingmin">7.84.1. Examples of MOVINGMIN</a></li>
+<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>
</ul>
</li>
-<li><a href="#movingstddev_function">7.85. MOVINGSTDDEV Function</a>
+<li><a href="#movingmax_function">7.85. MOVINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingstddev">7.85.1. Examples of MOVINGSTDDEV</a></li>
+<li><a href="#examples_of_movingmax">7.85.1. Examples of MOVINGMAX</a></li>
</ul>
</li>
-<li><a href="#movingsum_function">7.86. MOVINGSUM Function</a>
+<li><a href="#movingmin_function">7.86. MOVINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_movingsum">7.86.1. Examples of MOVINGSUM</a></li>
+<li><a href="#examples_of_movingmin">7.86.1. Examples of MOVINGMIN</a></li>
</ul>
</li>
-<li><a href="#movingvariance_function">7.87. MOVINGVARIANCE Function</a>
+<li><a href="#movingstddev_function">7.87. MOVINGSTDDEV Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_movingstddev">7.87.1. Examples of MOVINGSTDDEV</a></li>
</ul>
</li>
-<li><a href="#nullifzero_function">7.88. NULLIFZERO Function</a>
+<li><a href="#movingsum_function">7.88. MOVINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_nullifzero">7.88.1. Examples of NULLIFZERO</a></li>
+<li><a href="#examples_of_movingsum">7.88.1. Examples of MOVINGSUM</a></li>
</ul>
</li>
-<li><a href="#nvl_function">7.89. NVL Function</a>
+<li><a href="#movingvariance_function">7.89. MOVINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_nvl">7.89.1. Examples of NVL</a></li>
+<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>
</ul>
</li>
-<li><a href="#octet_length_function">7.90. OCTET_LENGTH Function</a>
+<li><a href="#nullifzero_function">7.90. NULLIFZERO Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_nullifzero">7.90.1. Examples of NULLIFZERO</a></li>
</ul>
</li>
-<li><a href="#pi_function">7.91. PI Function</a>
+<li><a href="#nvl_function">7.91. NVL Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_pi">7.91.1. Examples of PI</a></li>
+<li><a href="#examples_of_nvl">7.91.1. Examples of NVL</a></li>
</ul>
</li>
-<li><a href="#position_function">7.92. POSITION Function</a>
+<li><a href="#octet_length_function">7.92. OCTET_LENGTH Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#power_function">7.93. POWER Function</a>
+<li><a href="#pi_function">7.93. PI Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_power">7.93.1. Examples of POWER</a></li>
+<li><a href="#examples_of_pi">7.93.1. Examples of PI</a></li>
</ul>
</li>
-<li><a href="#quarter_function">7.94. QUARTER Function</a>
+<li><a href="#position_function">7.94. POSITION Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_quarter">7.94.1. Examples of QUARTER</a></li>
+<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>
</ul>
</li>
-<li><a href="#radians_function">7.95. RADIANS Function</a>
+<li><a href="#power_function">7.95. POWER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_radians">7.95.1. Examples of RADIANS</a></li>
+<li><a href="#examples_of_power">7.95.1. Examples of POWER</a></li>
</ul>
</li>
-<li><a href="#runningrank_function">7.96. RANK/RUNNINGRANK Function</a>
+<li><a href="#quarter_function">7.96. QUARTER Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_quarter">7.96.1. Examples of QUARTER</a></li>
</ul>
</li>
-<li><a href="#repeat_function">7.97. REPEAT Function</a>
+<li><a href="#radians_function">7.97. RADIANS Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_repeat">7.97.1. Examples of REPEAT</a></li>
+<li><a href="#examples_of_radians">7.97.1. Examples of RADIANS</a></li>
</ul>
</li>
-<li><a href="#replace_function">7.98. REPLACE Function</a>
+<li><a href="#runningrank_function">7.98. RANK/RUNNINGRANK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_replace">7.98.1. Examples of REPLACE</a></li>
+<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>
</ul>
</li>
-<li><a href="#right_function">7.99. RIGHT Function</a>
+<li><a href="#repeat_function">7.99. REPEAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_right">7.99.1. Examples of RIGHT</a></li>
+<li><a href="#examples_of_repeat">7.99.1. Examples of REPEAT</a></li>
</ul>
</li>
-<li><a href="#rollup_function">7.100. ROLLUP Function</a>
+<li><a href="#replace_function">7.100. REPLACE Function</a>
<ul class="sectlevel3">
-<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_replace">7.100.1. Examples of REPLACE</a></li>
</ul>
</li>
-<li><a href="#round_function">7.101. ROUND Function</a>
+<li><a href="#right_function">7.101. RIGHT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_round">7.101.1. Examples of ROUND</a></li>
+<li><a href="#examples_of_right">7.101.1. Examples of RIGHT</a></li>
</ul>
</li>
-<li><a href="#rows_since_function">7.102. ROWS SINCE Function</a>
+<li><a href="#rollup_function">7.102. ROLLUP Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#rows_since_changed_function">7.103. ROWS SINCE CHANGED Function</a>
+<li><a href="#round_function">7.103. ROUND Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_round">7.103.1. Examples of ROUND</a></li>
</ul>
</li>
-<li><a href="#rpad_function">7.104. RPAD Function</a>
+<li><a href="#rows_since_function">7.104. ROWS SINCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_rpad_function">7.104.1. Examples of RPAD Function</a></li>
+<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>
</ul>
</li>
-<li><a href="#rtrim_function">7.105. RTRIM Function</a>
+<li><a href="#rows_since_changed_function">7.105. ROWS SINCE CHANGED Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#runningavg_function">7.106. RUNNINGAVG Function</a>
+<li><a href="#rpad_function">7.106. RPAD Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_rpad_function">7.106.1. Examples of RPAD Function</a></li>
</ul>
</li>
-<li><a href="#runningcount_function">7.107. RUNNINGCOUNT Function</a>
+<li><a href="#rtrim_function">7.107. RTRIM Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#runningmax_function">7.108. RUNNINGMAX Function</a>
+<li><a href="#runningavg_function">7.108. RUNNINGAVG Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmax">7.108.1. Examples of RUNNINGMAX</a></li>
+<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>
</ul>
</li>
-<li><a href="#runningmin_function">7.109. RUNNINGMIN Function</a>
+<li><a href="#runningcount_function">7.109. RUNNINGCOUNT Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#runningsum_function">7.110. RUNNINGSUM Function</a>
+<li><a href="#runningmax_function">7.110. RUNNINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningsum">7.110.1. Examples of RUNNINGSUM</a></li>
+<li><a href="#examples_of_runningmax">7.110.1. Examples of RUNNINGMAX</a></li>
</ul>
</li>
-<li><a href="#runningvariance_function">7.111. RUNNINGVARIANCE Function</a>
+<li><a href="#runningmin_function">7.111. RUNNINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningvariance">7.111.1. Examples of RUNNINGVARIANCE</a></li>
+<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>
</ul>
</li>
-<li><a href="#second_function">7.112. SECOND Function</a>
+<li><a href="#runningsum_function">7.112. RUNNINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_second">7.112.1. Examples of SECOND</a></li>
+<li><a href="#examples_of_runningsum">7.112.1. Examples of RUNNINGSUM</a></li>
</ul>
</li>
-<li><a href="#sha_function">7.113. SHA Function</a>
+<li><a href="#runningvariance_function">7.113. RUNNINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha">7.113.1. examples of SHA</a></li>
+<li><a href="#examples_of_runningvariance">7.113.1. Examples of RUNNINGVARIANCE</a></li>
</ul>
</li>
-<li><a href="#sha2_function">7.114. SHA2 Function</a>
+<li><a href="#second_function">7.114. SECOND Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha2">7.114.1. examples of SHA2</a></li>
+<li><a href="#examples_of_second">7.114.1. Examples of SECOND</a></li>
</ul>
</li>
-<li><a href="#sign_function">7.115. SIGN Function</a>
+<li><a href="#sha_function">7.115. SHA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sign">7.115.1. Examples of SIGN</a></li>
+<li><a href="#examples_of_sha">7.115.1. examples of SHA</a></li>
</ul>
</li>
-<li><a href="#sin_function">7.116. SIN Function</a>
+<li><a href="#sha2_function">7.116. SHA2 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sin">7.116.1. Examples of SIN</a></li>
+<li><a href="#examples_of_sha2">7.116.1. examples of SHA2</a></li>
</ul>
</li>
-<li><a href="#sinh_function">7.117. SINH Function</a>
+<li><a href="#sign_function">7.117. SIGN Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_sign">7.117.1. Examples of SIGN</a></li>
</ul>
</li>
-<li><a href="#sqrt_function">7.118. SQRT Function</a>
+<li><a href="#sin_function">7.118. SIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sqrt">7.118.1. Examples of SQRT</a></li>
+<li><a href="#examples_of_sin">7.118.1. Examples of SIN</a></li>
</ul>
</li>
-<li><a href="#stddev_function">7.119. STDDEV Function</a>
+<li><a href="#sinh_function">7.119. SINH Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#stringtolob_function">7.120. STRINGTOLOB Function</a>
+<li><a href="#sqrt_function">7.120. SQRT Function</a>
<ul class="sectlevel3">
-<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>
+<li><a href="#examples_of_sqrt">7.120.1. Examples of SQRT</a></li>
</ul>
</li>
-<li><a href="#substring_function">7.121. SUBSTRING/SUBSTR Function</a>
+<li><a href="#stddev_function">7.121. STDDEV Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#sum_function">7.122. SUM Function</a>
+<li><a href="#stringtolob_function">7.122. STRINGTOLOB Function</a>
<ul class="sectlevel3">
-<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>
+<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>
</ul>
</li>
-<li><a href="#sysdate_function">7.123. SYSDATE Function</a>
+<li><a href="#substring_function">7.123. SUBSTRING/SUBSTR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sysdate">7.123.1. Examples of SYSDATE</a></li>
+<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>
</ul>
</li>
-<li><a href="#systimestamp_function">7.124. SYSTIMESTAMP Function</a>
+<li><a href="#sum_function">7.124. SUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_systimestamp">7.124.1. Examples of SYSTIMESTAMP</a></li>
+<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>
</ul>
</li>
-<li><a href="#tan_function">7.125. TAN Function</a>
+<li><a href="#sysdate_function">7.125. SYSDATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_tan">7.125.1. Examples of TAN</a></li>
-<li><a href="#tanh_function">7.125.2. TANH Function</a></li>
-<li><a href="#examples_of_tanh">7.125.3. Examples of TANH</a></li>
+<li><a href="#examples_of_sysdate">7.125.1. Examples of SYSDATE</a></li>
</ul>
</li>
-<li><a href="#this_function">7.126. THIS Function</a>
+<li><a href="#systimestamp_function">7.126. SYSTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_this">7.126.1. Considerations for THIS</a></li>
-<li><a href="#examples_of_this">7.126.2. Examples of THIS</a></li>
+<li><a href="#examples_of_systimestamp">7.126.1. Examples of SYSTIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#timestampadd_function">7.127. TIMESTAMPADD Function</a>
+<li><a href="#tan_function">7.127. TAN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampadd">7.127.1. Examples of TIMESTAMPADD</a></li>
+<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>
</ul>
</li>
-<li><a href="#timestampdiff_function">7.128. TIMESTAMPDIFF Function</a>
+<li><a href="#this_function">7.128. THIS Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampdiff">7.128.1. Examples of TIMESTAMPDIFF</a></li>
+<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>
</ul>
</li>
-<li><a href="#to_char_function">7.129. TO_CHAR Function</a>
+<li><a href="#timestampadd_function">7.129. TIMESTAMPADD Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_char">7.129.1. Considerations for TO_CHAR</a></li>
-<li><a href="#examples_of_to_char">7.129.2. Examples of TO_CHAR</a></li>
+<li><a href="#examples_of_timestampadd">7.129.1. Examples of TIMESTAMPADD</a></li>
</ul>
</li>
-<li><a href="#to_date_function">7.130. TO_DATE Function</a>
+<li><a href="#timestampdiff_function">7.130. TIMESTAMPDIFF Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_date">7.130.1. Considerations for TO_DATE</a></li>
-<li><a href="#examples_of_to_date">7.130.2. Examples of TO_DATE</a></li>
+<li><a href="#examples_of_timestampdiff">7.130.1. Examples of TIMESTAMPDIFF</a></li>
</ul>
</li>
-<li><a href="#to_time_function">7.131. TO_TIME Function</a>
+<li><a href="#to_char_function">7.131. TO_CHAR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_time">7.131.1. Examples of TO_TIME</a></li>
+<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>
</ul>
</li>
-<li><a href="#to_timestamp_function">7.132. TO_TIMESTAMP Function</a>
+<li><a href="#to_date_function">7.132. TO_DATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_timestamp">7.132.1. Example of TO_TIMESTAMP</a></li>
+<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>
</ul>
</li>
-<li><a href="#translate_function">7.133. TRANSLATE Function</a></li>
-<li><a href="#trim_function">7.134. TRIM Function</a>
+<li><a href="#to_time_function">7.133. TO_TIME Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_trim">7.134.1. Considerations for TRIM</a></li>
-<li><a href="#examples_of_trim">7.134.2. Examples of TRIM</a></li>
+<li><a href="#examples_of_to_time">7.133.1. Examples of TO_TIME</a></li>
</ul>
</li>
-<li><a href="#ucase_function">7.135. UCASE Function</a>
+<li><a href="#to_timestamp_function">7.134. TO_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_ucase">7.135.1. Considerations for UCASE</a></li>
-<li><a href="#examples_of_ucase">7.135.2. Examples of UCASE</a></li>
-<li><a href="#upper_function">7.135.3. UPPER Function</a></li>
-<li><a href="#examples_of_upper">7.135.4. Examples of UPPER</a></li>
-<li><a href="#upshift_function">7.135.5. UPSHIFT Function</a></li>
-<li><a href="#examples_of_upshift">7.135.6. Examples of UPSHIFT</a></li>
+<li><a href="#examples_of_to_timestamp">7.134.1. Example of TO_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#user_function">7.136. USER Function</a>
+<li><a href="#translate_function">7.135. TRANSLATE Function</a></li>
+<li><a href="#trim_function">7.136. TRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_user">7.136.1. Considerations for USER</a></li>
-<li><a href="#examples_of_user">7.136.2. Examples of USER</a></li>
+<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>
</ul>
</li>
-<li><a href="#variance_function">7.137. VARIANCE Function</a>
+<li><a href="#ucase_function">7.137. UCASE Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_variance">7.137.1. Considerations for VARIANCE</a></li>
-<li><a href="#examples_of_variance">7.137.2. Examples of VARIANCE</a></li>
+<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>
</ul>
</li>
-<li><a href="#week_function">7.138. WEEK Function</a>
+<li><a href="#rand_function">7.138. RAND Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_week">7.138.1. Examples of WEEK</a></li>
+<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>
</ul>
</li>
-<li><a href="#year_function">7.139. YEAR Function</a>
+<li><a href="#user_function">7.139. USER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_year">7.139.1. Examples of YEAR</a></li>
+<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>
</ul>
</li>
-<li><a href="#zeroifnull_function">7.140. ZEROIFNULL Function</a>
+<li><a href="#variance_function">7.140. VARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_zeroifnull">7.140.1. Examples of ZEROIFNULL</a></li>
+<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>
+</ul>
+</li>
+<li><a href="#week_function">7.141. WEEK Function</a>
+<ul class="sectlevel3">
+<li><a href="#examples_of_week">7.141.1. Examples of WEEK</a></li>
+</ul>
+</li>
+<li><a href="#year_function">7.142. YEAR Function</a>
+<ul class="sectlevel3">
+<li><a href="#examples_of_year">7.142.1. Examples of YEAR</a></li>
+</ul>
+</li>
+<li><a href="#zeroifnull_function">7.143. ZEROIFNULL Function</a>
+<ul class="sectlevel3">
+<li><a href="#examples_of_zeroifnull">7.143.1. Examples of ZEROIFNULL</a></li>
</ul>
</li>
</ul>
@@ -32662,8 +32675,9 @@ approximately 1.8884, the hyperbolic cosine of 1.25 in radians:</p>
</div>
<div style="page-break-after: always;"></div>
</div>
-<div class="sect3">
-<h4 id="count_function">7.30.4. COUNT Function</h4>
+</div>
+<div class="sect2">
+<h3 id="count_function">7.31. COUNT Function</h3>
<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.
@@ -32707,9 +32721,8 @@ values from the one-column table derived from the evaluation of
</li>
</ul>
</div>
-</div>
<div class="sect3">
-<h4 id="considerations_for_count">7.30.5. Considerations for COUNT</h4>
+<h4 id="considerations_for_count">7.31.1. Considerations for COUNT</h4>
<div class="sect4">
<h5 id="operands-of-the-expression-1">Operands of the Expression</h5>
<div class="paragraph">
@@ -32741,7 +32754,7 @@ COUNT(\*) returns the number of rows in the table.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_count">7.30.6. Examples of COUNT</h4>
+<h4 id="examples_of_count">7.31.2. Examples of COUNT</h4>
<div class="ulist">
<ul>
<li>
@@ -32834,7 +32847,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_crc32">7.30.7. examples of CR32</h4>
+<h4 id="examples_of_crc32">7.31.3. examples of CR32</h4>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">>>SELECT CRC32('Trafodion') from dual;
@@ -32856,7 +32869,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="current_function">7.31. CURRENT Function</h3>
+<h3 id="current_function">7.32. 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>
@@ -32892,7 +32905,7 @@ not a string value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_current">7.31.1. Examples of CURRENT</h4>
+<h4 id="examples_of_current">7.32.1. Examples of CURRENT</h4>
<div class="ulist">
<ul>
<li>
@@ -32911,7 +32924,7 @@ SET ship_timestamp = CURRENT WHERE projcode = 1000;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="current_date_function">7.32. CURRENT_DATE Function</h3>
+<h3 id="current_date_function">7.33. CURRENT_DATE Function</h3>
<div class="paragraph">
<p>The CURRENT_DATE function returns the local current date as a value of
type DATE.</p>
@@ -32930,7 +32943,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.32.1. Examples of CURRENT_DATE</h4>
+<h4 id="examples_of_current_date">7.33.1. Examples of CURRENT_DATE</h4>
<div class="ulist">
<ul>
<li>
@@ -32969,7 +32982,7 @@ THE WORKS 2008-02-02
</div>
</div>
<div class="sect2">
-<h3 id="current_time_function">7.33. CURRENT_TIME Function</h3>
+<h3 id="current_time_function">7.34. CURRENT_TIME Function</h3>
<div class="paragraph">
<p>The CURRENT_TIME function returns the current local time as a value of
type TIME.</p>
@@ -33002,7 +33015,7 @@ value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_current_time">7.33.1. Examples of CURRENT_TIME</h4>
+<h4 id="examples_of_current_time">7.34.1. Examples of CURRENT_TIME</h4>
<div class="ulist">
<ul>
<li>
@@ -33020,7 +33033,7 @@ VALUES (001, CURRENT_DATE, CURRENT_TIME, 'JuBrock');</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="current_timestamp_function">7.34. CURRENT_TIMESTAMP Function</h3>
+<h3 id="current_timestamp_function">7.35. 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>
@@ -33056,7 +33069,7 @@ returned is not a string value.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_current_timestamp">7.34.1. Examples of CURRENT_TIMESTAMP</h4>
+<h4 id="examples_of_current_timestamp">7.35.1. Examples of CURRENT_TIMESTAMP</h4>
<div class="ulist">
<ul>
<li>
@@ -33075,7 +33088,7 @@ SET ship_timestamp = CURRENT_TIMESTAMP WHERE projcode = 1000;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="current_user_function">7.35. CURRENT_USER Function</h3>
+<h3 id="current_user_function">7.36. 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
@@ -33091,7 +33104,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.35.1. Considerations for CURRENT_USER</h4>
+<h4 id="considerations_for_current_user">7.36.1. Considerations for CURRENT_USER</h4>
<div class="ulist">
<ul>
<li>
@@ -33104,7 +33117,7 @@ authorization of SQL statements in the current session.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_current_user">7.35.2. Examples of CURRENT_USER</h4>
+<h4 id="examples_of_current_user">7.36.2. Examples of CURRENT_USER</h4>
<div class="ulist">
<ul>
<li>
@@ -33127,7 +33140,7 @@ TSHAW
</div>
</div>
<div class="sect2">
-<h3 id="date_add_function">7.36. DATE_ADD Function</h3>
+<h3 id="date_add_function">7.37. 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
@@ -33166,7 +33179,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.36.1. Examples of DATE_ADD</h4>
+<h4 id="examples_of_date_add">7.37.1. Examples of DATE_ADD</h4>
<div class="ulist">
<ul>
<li>
@@ -33219,7 +33232,7 @@ compare this example with the last example under DATE_SUB.
</div>
</div>
<div class="sect2">
-<h3 id="date_sub_function">7.37. DATE_SUB Function</h3>
+<h3 id="date_sub_function">7.38. 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,
@@ -33259,7 +33272,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.37.1. Examples of DATE_SUB</h4>
+<h4 id="examples_of_date_sub">7.38.1. Examples of DATE_SUB</h4>
<div class="ulist">
<ul>
<li>
@@ -33300,7 +33313,7 @@ expressions. see <a href="#interval_value_expressions">Interval Value Expression
</div>
</div>
<div class="sect2">
-<h3 id="dateadd_function">7.38. DATEADD Function</h3>
+<h3 id="dateadd_function">7.39. 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
@@ -33389,7 +33402,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.38.1. Examples of DATEADD</h4>
+<h4 id="examples_of_dateadd">7.39.1. Examples of DATEADD</h4>
<div class="ulist">
<ul>
<li>
@@ -33430,7 +33443,7 @@ returned. See <a href="#datetime_value_expressions">Datetime Value Expressions</
</div>
</div>
<div class="sect2">
-<h3 id="datediff_function">7.39. DATEDIFF Function</h3>
+<h3 id="datediff_function">7.40. DATEDIFF Function</h3>
<div class="paragraph">
<p>The DATEDIFF function returns the integer for the number of
<em>datepart</em> units of time between <em>startdate</em> and <em>enddate</em>.</p>
@@ -33445,7 +33458,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.39.1. Syntax Description of DATEDIFF</h4>
+<h4 id="syntax_description_of_datediff">7.40.1. Syntax Description of DATEDIFF</h4>
<div class="ulist">
<ul>
<li>
@@ -33513,7 +33526,7 @@ See <a href="#datetime_value_expressions">Datetime Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_datediff">7.39.2. Considerations for DATEDIFF</h4>
+<h4 id="considerations_for_datediff">7.40.2. Considerations for DATEDIFF</h4>
<div class="sect4">
<h5 id="boundary">Boundary</h5>
<div class="paragraph">
@@ -33606,7 +33619,7 @@ See <a href="#datetime_value_expressions">Datetime Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_datediff">7.39.3. Examples of DATEDIFF</h4>
+<h4 id="examples_of_datediff">7.40.3. Examples of DATEDIFF</h4>
<div class="sect4">
<h5 id="date_difference_in_second">Date Difference in SECOND</h5>
<div class="ulist">
@@ -33751,7 +33764,7 @@ FROM DUAL;</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="date_difference_in_year">7.39.4. Date Difference in YEAR</h4>
+<h4 id="date_difference_in_year">7.40.4. Date Difference in YEAR</h4>
<div class="ulist">
<ul>
<li>
@@ -33784,7 +33797,7 @@ FROM DUAL;</code></pre>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="dateformat_function">7.39.5. DATEFORMAT Function</h4>
+<h4 id="dateformat_function">7.40.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
@@ -33817,14 +33830,14 @@ or TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressio
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_dateformat">7.39.6. Considerations for DATEFORMAT</h4>
+<h4 id="considerations_for_dateformat">7.40.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.39.7. Examples of DATEFORMAT</h4>
+<h4 id="examples_of_dateformat">7.40.7. Examples of DATEFORMAT</h4>
<div class="ulist">
<ul>
<li>
@@ -33853,7 +33866,7 @@ function returns this string literal:</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_part_function_of_an_interval">7.40. DATE_PART Function (of an Interval)</h3>
+<h3 id="date_part_function_of_an_interval">7.41. 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
@@ -33898,7 +33911,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.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>
@@ -33931,7 +33944,7 @@ quotes.</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_part_function_of_a_timestamp">7.41. DATE_PART Function (of a Timestamp)</h3>
+<h3 id="date_part_function_of_a_timestamp">7.42. 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
@@ -33997,7 +34010,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.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>
@@ -34038,7 +34051,7 @@ and YEARWEEK text specification with EXTRACT.</p>
</div>
</div>
<div class="sect2">
-<h3 id="date_trunc_function">7.42. DATE_TRUNC Function</h3>
+<h3 id="date_trunc_function">7.43. 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
@@ -34074,7 +34087,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.42.1. Examples of DATE_TRUNC</h4>
+<h4 id="examples_of_date_trunc">7.43.1. Examples of DATE_TRUNC</h4>
<div class="ulist">
<ul>
<li>
@@ -34120,7 +34133,7 @@ months or days). See <a href="#datetime_value_expressions">Datetime Value Expres
</div>
</div>
<div class="sect2">
-<h3 id="day_function">7.43. DAY Function</h3>
+<h3 id="day_function">7.44. 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
@@ -34147,7 +34160,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_day">7.43.1. Examples of Day</h4>
+<h4 id="examples_of_day">7.44.1. Examples of Day</h4>
<div class="ulist">
<ul>
<li>
@@ -34171,7 +34184,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayname_function">7.44. DAYNAME Function</h3>
+<h3 id="dayname_function">7.45. 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,
@@ -34197,13 +34210,13 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_dayname">7.44.1. Considerations for DAYNAME</h4>
+<h4 id="considerations_for_dayname">7.45.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.44.2. Examples of DAYNAME</h4>
+<h4 id="examples_of_dayname">7.45.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>
@@ -34223,7 +34236,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofmonth_function">7.45. DAYOFMONTH Function</h3>
+<h3 id="dayofmonth_function">7.46. 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
@@ -34250,7 +34263,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofmonth">7.45.1. Examples of DAYOFMONTH</h4>
+<h4 id="examples_of_dayofmonth">7.46.1. Examples of DAYOFMONTH</h4>
<div class="ulist">
<ul>
<li>
@@ -34274,7 +34287,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofweek_function">7.46. DAYOFWEEK Function</h3>
+<h3 id="dayofweek_function">7.47. 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
@@ -34301,7 +34314,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofweek">7.46.1. Examples of DAYOFWEEK</h4>
+<h4 id="examples_of_dayofweek">7.47.1. Examples of DAYOFWEEK</h4>
<div class="ulist">
<ul>
<li>
@@ -34328,7 +34341,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="dayofyear_function">7.47. DAYOFYEAR Function</h3>
+<h3 id="dayofyear_function">7.48. 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
@@ -34354,7 +34367,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_dayofyear">7.47.1. Examples of DAYOFYEAR</h4>
+<h4 id="examples_of_dayofyear">7.48.1. Examples of DAYOFYEAR</h4>
<div class="ulist">
<ul>
<li>
@@ -34378,7 +34391,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="Decode_function">7.48. DECODE Function</h3>
+<h3 id="Decode_function">7.49. 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
@@ -34423,7 +34436,7 @@ returned.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_decode">7.48.1. Considerations for DECODE</h4>
+<h4 id="considerations_for_decode">7.49.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
@@ -34556,7 +34569,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.48.2. Examples of DECODE</h4>
+<h4 id="_examples_of_decode">7.49.2. Examples of DECODE</h4>
<div class="ulist">
<ul>
<li>
@@ -34623,7 +34636,7 @@ value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="degrees_function">7.49. DEGREES Function</h3>
+<h3 id="degrees_function">7.50. DEGREES Function</h3>
<div class="paragraph">
<p>The DEGREES function converts a numeric value expression expressed in
radians to the number of degrees.</p>
@@ -34649,7 +34662,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_degrees">7.49.1. Examples of Degrees</h4>
+<h4 id="examples_of_degrees">7.50.1. Examples of Degrees</h4>
<div class="ulist">
<ul>
<li>
@@ -34675,7 +34688,7 @@ inverse of the function radians.</p>
</div>
</div>
<div class="sect2">
-<h3 id="diff1_function">7.50. DIFF1 Function</h3>
+<h3 id="diff1_function">7.51. 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
@@ -34719,7 +34732,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.50.1. Considerations for DIFF1</h4>
+<h4 id="considerations_for_diff1">7.51.1. Considerations for DIFF1</h4>
<div class="sect4">
<h5 id="equivalent-result">Equivalent Result</h5>
<div class="paragraph">
@@ -34750,7 +34763,7 @@ division by a value of INTERVAL data type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_diff1">7.50.2. Examples of DIFF1</h4>
+<h4 id="examples_of_diff1">7.51.2. Examples of DIFF1</h4>
<div class="ulist">
<ul>
<li>
@@ -34840,7 +34853,7 @@ example, 0.0007319 is equal to 21959 divided by 30002620.</p>
</div>
</div>
<div class="sect2">
-<h3 id="diff2_function">7.51. DIFF2 Function</h3>
+<h3 id="diff2_function">7.52. 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
@@ -34880,7 +34893,7 @@ See <a href="#diff1_function">DIFF1 Function</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_diff2">7.51.1. Considerations for DIFF2</h4>
+<h4 id="considerations_for_diff2">7.52.1. Considerations for DIFF2</h4>
<div class="sect4">
<h5 id="equivalent_result_1">Equivalent Result</h5>
<div class="ulist">
@@ -34921,7 +34934,7 @@ division by a value of INTERVAL data type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_diff2">7.51.2. Examples of DIFF2</h4>
+<h4 id="examples_of_diff2">7.52.2. Examples of DIFF2</h4>
<div class="ulist">
<ul>
<li>
@@ -34979,9 +34992,9 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="emptyblob_function">7.52. EMPTY_BLOB() Function</h3>
+<h3 id="emptyblob_function">7.53. EMPTY_BLOB() Function</h3>
<div class="sect3">
-<h4 id="syntax_descriptions_of_emptyblob_function">7.52.1. Syntax Descriptions of EMPTY_BLOB() Function</h4>
+<h4 id="syntax_descriptions_of_emptyblob_function">7.53.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>
@@ -35001,7 +35014,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_emptyblob_function">7.52.2. Considerations for EMPTY_BLOB() Function</h4>
+<h4 id="considerations_for_emptyblob_function">7.53.2. Considerations for EMPTY_BLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35037,7 +35050,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_emptyblob_function">7.52.3. Examples of EMPTY_BLOB() Function</h4>
+<h4 id="examples_of_emptyblob_function">7.53.3. Examples of EMPTY_BLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35054,9 +35067,9 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="emptyclob_function">7.53. EMPTY_CLOB() Function</h3>
+<h3 id="emptyclob_function">7.54. EMPTY_CLOB() Function</h3>
<div class="sect3">
-<h4 id="syntax_descriptions_of_emptyclob_function">7.53.1. Syntax Descriptions of EMPTY_CLOB() Function</h4>
+<h4 id="syntax_descriptions_of_emptyclob_function">7.54.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>
@@ -35076,7 +35089,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_emptyclob_function">7.53.2. Considerations for EMPTY_CLOB() Function</h4>
+<h4 id="considerations_for_emptyclob_function">7.54.2. Considerations for EMPTY_CLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35102,7 +35115,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_emptyclob_function">7.53.3. Examples of EMPTY_CLOB() Function</h4>
+<h4 id="examples_of_emptyclob_function">7.54.3. Examples of EMPTY_CLOB() Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35119,7 +35132,7 @@ DIFF2_I1TS
</div>
</div>
<div class="sect2">
-<h3 id="exp_function">7.54. EXP Function</h3>
+<h3 id="exp_function">7.55. 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>
@@ -35149,7 +35162,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.54.1. Examples of EXP</h4>
+<h4 id="examples_of_exp">7.55.1. Examples of EXP</h4>
<div class="ulist">
<ul>
<li>
@@ -35176,7 +35189,7 @@ of the function LOG:</p>
</div>
</div>
<div class="sect2">
-<h3 id="explain_function">7.55. EXPLAIN Function</h3>
+<h3 id="explain_function">7.56. 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
@@ -35236,7 +35249,7 @@ name in a PREPARE statement.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_explain_function">7.55.1. Considerations for EXPLAIN Function</h4>
+<h4 id="considerations_for_explain_function">7.56.1. Considerations for EXPLAIN Function</h4>
<div class="sect4">
<h5 id="using_a_statement_pattern">Using a Statement Pattern</h5>
<div class="paragraph">
@@ -35476,7 +35489,7 @@ a nested-loop join.</p></td>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_explain_function">7.55.2. Examples of EXPLAIN Function</h4>
+<h4 id="examples_of_explain_function">7.56.2. Examples of EXPLAIN Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35508,9 +35521,9 @@ then selects the desired columns.</p>
</div>
</div>
<div class="sect2">
-<h3 id="externaltolob_function">7.56. EXTERNALTOLOB Function</h3>
+<h3 id="externaltolob_function">7.57. EXTERNALTOLOB Function</h3>
<div class="sect3">
-<h4 id="externaltolob_function_syntax">7.56.1. Syntax Descriptions of EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_syntax">7.57.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>
@@ -35533,7 +35546,7 @@ hdfs:///{local hdfs file name}</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="externaltolob_function_considerations">7.56.2. Considerations for EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_considerations">7.57.2. Considerations for EXTERNALTOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35546,7 +35559,7 @@ hdfs:///{local hdfs file name}</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="externaltolob_function_examples">7.56.3. Examples of EXTERNALTOLOB Function</h4>
+<h4 id="externaltolob_function_examples">7.57.3. Examples of EXTERNALTOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35573,7 +35586,7 @@ externaltolob('hdfs:///lobs/lob_input_a1.txt'));</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="extract_function">7.57. EXTRACT Function</h3>
+<h3 id="extract_function">7.58. 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>
@@ -35604,7 +35617,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.57.1. Examples of EXTRACT</h4>
+<h4 id="examples_of_extract">7.58.1. Examples of EXTRACT</h4>
<div class="ulist">
<ul>
<li>
@@ -35635,9 +35648,9 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="filetolob_function">7.58. FILETOLOB Function</h3>
+<h3 id="filetolob_function">7.59. FILETOLOB Function</h3>
<div class="sect3">
-<h4 id="filetolob_function_syntax">7.58.1. Syntax Descriptions of FILETOLOB Function</h4>
+<h4 id="filetolob_function_syntax">7.59.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>
@@ -35664,7 +35677,7 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect3">
-<h4 id="filetolob_function_examples">7.58.2. Examples of FILETOLOB Function</h4>
+<h4 id="filetolob_function_examples">7.59.2. Examples of FILETOLOB Function</h4>
<div class="ulist">
<ul>
<li>
@@ -35689,7 +35702,7 @@ interval value expression. It returns an exact numeric value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="group_concat_function">7.59. GROUP_CONCAT Function</h3>
+<h3 id="group_concat_function">7.60. 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.
@@ -35714,7 +35727,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.59.1. Examples of GROUP_CONCAT</h4>
+<h4 id="examples_of_group_concat">7.60.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>
@@ -35735,7 +35748,7 @@ tom 91 77 43</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="hour_function">7.60. HOUR Function</h3>
+<h3 id="hour_function">7.61. 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
@@ -35761,7 +35774,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_hour">7.60.1. Examples of HOUR</h4>
+<h4 id="examples_of_hour">7.61.1. Examples of HOUR</h4>
<div class="ulist">
<ul>
<li>
@@ -35786,7 +35799,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="insert_function">7.61. INSERT Function</h3>
+<h3 id="insert_function">7.62. 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
@@ -35836,7 +35849,7 @@ or equal to the length of <em>char-expr-1</em>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_insert">7.61.1. Examples of INSERT</h4>
+<h4 id="examples_of_insert">7.62.1. Examples of INSERT</h4>
<div class="ulist">
<ul>
<li>
@@ -35870,7 +35883,7 @@ SALES REP
</div>
</div>
<div class="sect2">
-<h3 id="is_ipv4_function">7.62. IS_IPV4 Function</h3>
+<h3 id="is_ipv4_function">7.63. 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>
@@ -35893,7 +35906,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_is_ipv4">7.62.1. Examples of IS_IPV4</h4>
+<h4 id="examples_of_is_ipv4">7.63.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>
@@ -35911,7 +35924,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="is_ipv6_function">7.63. IS_IPV6 Function</h3>
+<h3 id="is_ipv6_function">7.64. 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>
@@ -35935,7 +35948,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_is_ipv6">7.63.1. Examples of IS_IPV6</h4>
+<h4 id="examples_of_is_ipv6">7.64.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>
@@ -35951,7 +35964,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="inet_aton_function">7.64. INET_ATON Function</h3>
+<h3 id="inet_aton_function">7.65. 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
@@ -35976,7 +35989,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_inet_aton">7.64.1. Examples of INET_ATON</h4>
+<h4 id="examples_of_inet_aton">7.65.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;
@@ -35990,7 +36003,7 @@ See <a href="#expressions">Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="inet_ntoa_function">7.65. INET_NTOA Function</h3>
+<h3 id="inet_ntoa_function">7.66. 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
@@ -36017,7 +36030,7 @@ See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_inet_ntoa">7.65.1. Examples of INET_NTOA</h4>
+<h4 id="examples_of_inet_ntoa">7.66.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>
@@ -36034,7 +36047,7 @@ representation of the IP address.</p>
</div>
</div>
<div class="sect2">
-<h3 id="isnull_function">7.66. ISNULL Function</h3>
+<h3 id="isnull_function">7.67. 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
@@ -36066,7 +36079,7 @@ with that of <em>ck-expr</em>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_isnull">7.66.1. Examples of ISNULL</h4>
+<h4 id="examples_of_isnull">7.67.1. Examples of ISNULL</h4>
<div class="ulist">
<ul>
<li>
@@ -36099,7 +36112,7 @@ with that of <em>ck-expr</em>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="juliantimestamp_function">7.67. JULIANTIMESTAMP Function</h3>
+<h3 id="juliantimestamp_function">7.68. 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
@@ -36135,14 +36148,14 @@ specified datetime value are set to zero. See
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_juliantimestamp">7.67.1. Considerations for JULIANTIMESTAMP</h4>
+<h4 id="considerations_for_juliantimestamp">7.68.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.67.2. Examples of JULIANTIMESTAMP</h4>
+<h4 id="examples_of_juliantimestamp">7.68.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>
@@ -36187,7 +36200,7 @@ START_DATE (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="lastnotnull_function">7.68. LASTNOTNULL Function</h3>
+<h3 id="lastnotnull_function">7.69. 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
@@ -36213,7 +36226,7 @@ expression. If only null values have been returned, LASTNOTNULL returns null.</p
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_lastnotnull">7.68.1. Examples of LASTNOTNULL</h4>
+<h4 id="examples_of_lastnotnull">7.69.1. Examples of LASTNOTNULL</h4>
<div class="ulist">
<ul>
<li>
@@ -36241,7 +36254,7 @@ lastnotnull
</div>
</div>
<div class="sect2">
-<h3 id="lcase_function">7.69. LCASE Function</h3>
+<h3 id="lcase_function">7.70. 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
@@ -36276,7 +36289,7 @@ characters to down-shift. See
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_lcase">7.69.1. Examples of LCASE</h4>
+<h4 id="examples_of_lcase">7.70.1. Examples of LCASE</h4>
<div class="ulist">
<ul>
<li>
@@ -36304,7 +36317,7 @@ Hotel Oregon HOTEL OREGON hotel oregon
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="left_function">7.69.2. LEFT Function</h4>
+<h4 id="left_function">7.70.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
@@ -36341,7 +36354,7 @@ than or equal to 0 with a scale of zero.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_left">7.69.3. Examples of LEFT</h4>
+<h4 id="examples_of_left">7.70.3. Examples of LEFT</h4>
<div class="ulist">
<ul>
<li>
@@ -36384,7 +36397,7 @@ SECRETARY COMNET
</div>
</div>
<div class="sect2">
-<h3 id="locate_function">7.70. LOCATE Function</h3>
+<h3 id="locate_function">7.71. 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
@@ -36427,7 +36440,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.70.1. Considerations for LOCATE</h4>
+<h4 id="considerations_for_locate">7.71.1. Considerations for LOCATE</h4>
<div class="sect4">
<h5 id="result_of_locate">Result of LOCATE</h5>
<div class="ulist">
@@ -36458,7 +36471,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.70.2. Examples of LOCATE</h4>
+<h4 id="examples_of_locate">7.71.2. Examples of LOCATE</h4>
<div class="ulist">
<ul>
<li>
@@ -36487,7 +36500,7 @@ WHERE LOCATE ('SMITH',UCASE(empname)) > 0 ;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="log_function">7.71. LOG Function</h3>
+<h3 id="log_function">7.72. 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>
@@ -36510,7 +36523,7 @@ than zero. See <a href="#numeric_value_expressions">Numeric Value Expressions</a
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_log">7.71.1. Examples of LOG</h4>
+<h4 id="examples_of_log">7.72.1. Examples of LOG</h4>
<div class="ulist">
<ul>
<li>
@@ -36527,7 +36540,7 @@ approximately 0.69315:</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="log10_function">7.71.2. LOG10 Function</h4>
+<h4 id="log10_function">7.72.2. LOG10 Function</h4>
<div class="paragraph">
<p>The LOG10 function returns the base 10 logarithm of a numeric value
expression.</p>
@@ -36555,7 +36568,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_log10">7.71.3. Examples of LOG10</h4>
+<h4 id="examples_of_log10">7.72.3. Examples of LOG10</h4>
<div class="ulist">
<ul>
<li>
@@ -36573,7 +36586,7 @@ approximately 1.3979:</p>
</div>
</div>
<div class="sect2">
-<h3 id="lower_function">7.72. LOWER Function</h3>
+<h3 id="lower_function">7.73. 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
@@ -36605,7 +36618,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_lower">7.72.1. Considerations for LOWER</h4>
+<h4 id="considerations_for_lower">7.73.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
@@ -36623,7 +36636,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.72.2. Examples of LOWER</h4>
+<h4 id="examples_of_lower">7.73.2. Examples of LOWER</h4>
<div class="ulist">
<ul>
<li>
@@ -36650,8 +36663,9 @@ Hotel Oregon HOTEL OREGON hotel oregon
</div>
<div style="page-break-after: always;"></div>
</div>
-<div class="sect3">
-<h4 id="lpad_function">7.72.3. LPAD Function</h4>
+</div>
+<div class="sect2">
+<h3 id="lpad_function">7.74. 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,
@@ -36691,9 +36705,8 @@ string size, the string is truncated.</p>
</li>
</ul>
</div>
-</div>
<div class="sect3">
-<h4 id="examples_of_lpad">7.72.4. Examples of LPAD</h4>
+<h4 id="examples_of_lpad">7.74.1. Examples of LPAD</h4>
<div class="ulist">
<ul>
<li>
@@ -36742,7 +36755,7 @@ string size, the string is truncated.</p>
</div>
</div>
<div class="sect2">
-<h3 id="ltrim_function">7.73. LTRIM Function</h3>
+<h3 id="ltrim_function">7.75. 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
@@ -36769,7 +36782,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_ltrim">7.73.1. Considerations for LTRIM</h4>
+<h4 id="considerations_for_ltrim">7.75.1. Considerations for LTRIM</h4>
<div class="sect4">
<h5 id="result_of_ltrim">Result of LTRIM</h5>
<div class="paragraph">
@@ -36779,7 +36792,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_ltrim">7.73.2. Examples of LTRIM</h4>
+<h4 id="examples_of_ltrim">7.75.2. Exa
<TRUNCATED>