http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/af4e9151/docs/2.3.0/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/index.html b/docs/2.3.0/sql_reference/index.html index 7499eb8..04fa99b 100644 --- a/docs/2.3.0/sql_reference/index.html +++ b/docs/2.3.0/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="minut
<TRUNCATED>
