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