http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/28c157d4/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 2fb2c9f..9c2297e 100644 --- a/docs/2.3.0/sql_reference/index.html +++ b/docs/2.3.0/sql_reference/index.html @@ -1229,699 +1229,742 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#_aggregate_set_functions">7.2. Aggregate (Set) Functions</a></li> <li><a href="#character_string_functions">7.3. Character String Functions</a></li> <li><a href="#datetime_functions">7.4. Datetime Functions</a></li> -<li><a href="#mathematical_functions">7.5. Mathematical Functions</a></li> -<li><a href="#encryption_functions">7.6. Encryption Functions</a></li> -<li><a href="#sequence_functions">7.7. Sequence Functions</a> +<li><a href="#lob_functions">7.5. LOB Functions</a></li> +<li><a href="#mathematical_functions">7.6. Mathematical Functions</a></li> +<li><a href="#encryption_functions">7.7. Encryption Functions</a></li> +<li><a href="#sequence_functions">7.8. Sequence Functions</a> <ul class="sectlevel3"> -<li><a href="#difference_sequence_functions">7.7.1. Difference sequence functions</a></li> -<li><a href="#moving_sequence_functions">7.7.2. Moving sequence functions</a></li> -<li><a href="#running_sequence_functions">7.7.3. Running sequence functions</a></li> -<li><a href="#other_sequence_functions">7.7.4. Other sequence functions</a></li> +<li><a href="#difference_sequence_functions">7.8.1. Difference sequence functions</a></li> +<li><a href="#moving_sequence_functions">7.8.2. Moving sequence functions</a></li> +<li><a href="#running_sequence_functions">7.8.3. Running sequence functions</a></li> +<li><a href="#other_sequence_functions">7.8.4. Other sequence functions</a></li> </ul> </li> -<li><a href="#other_functions_and_expressions">7.8. Other Functions and Expressions</a></li> -<li><a href="#abs_function">7.9. ABS Function</a> +<li><a href="#other_functions_and_expressions">7.9. Other Functions and Expressions</a></li> +<li><a href="#abs_function">7.10. ABS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_abs">7.9.1. Examples of ABS</a></li> +<li><a href="#examples_of_abs">7.10.1. Examples of ABS</a></li> </ul> </li> -<li><a href="#acos_function">7.10. ACOS Function</a> +<li><a href="#acos_function">7.11. ACOS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_acos">7.10.1. Examples of ACOS</a></li> -<li><a href="#add_months_function">7.10.2. ADD_MONTHS Function</a></li> -<li><a href="#examples_of_add_months">7.10.3. Examples of ADD_MONTHS</a></li> +<li><a href="#examples_of_acos">7.11.1. Examples of ACOS</a></li> +<li><a href="#add_months_function">7.11.2. ADD_MONTHS Function</a></li> +<li><a href="#examples_of_add_months">7.11.3. Examples of ADD_MONTHS</a></li> </ul> </li> -<li><a href="#ascii_function">7.11. ASCII Function</a> +<li><a href="#ascii_function">7.12. ASCII Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ascii">7.11.1. Considerations For ASCII</a></li> -<li><a href="#examples_of_ascii">7.11.2. Examples of ASCII</a></li> +<li><a href="#considerations_for_ascii">7.12.1. Considerations For ASCII</a></li> +<li><a href="#examples_of_ascii">7.12.2. Examples of ASCII</a></li> </ul> </li> -<li><a href="#asin_function">7.12. ASIN Function</a> +<li><a href="#asin_function">7.13. ASIN Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ascii">7.12.1. Considerations for ASCII</a></li> -<li><a href="#examples_of_ascii">7.12.2. Examples of ASCII</a></li> +<li><a href="#considerations_for_ascii">7.13.1. Considerations for ASCII</a></li> +<li><a href="#examples_of_ascii">7.13.2. Examples of ASCII</a></li> </ul> </li> -<li><a href="#asin_function">7.13. ASIN Function</a> +<li><a href="#asin_function">7.14. ASIN Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_asin">7.14.1. Examples of ASIN</a></li> +</ul> +</li> +<li><a href="#atan_function">7.15. ATAN Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_atan">7.15.1. Examples of ATAN</a></li> +</ul> +</li> +<li><a href="#atan2_function">7.16. ATAN2 Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_atan2">7.16.1. Examples of ATAN2</a></li> +</ul> +</li> +<li><a href="#authname_function">7.17. AUTHNAME Function</a> +<ul class="sectlevel3"> +<li><a href="#considerations_for_authname">7.17.1. Considerations for AUTHNAME</a></li> +<li><a href="#examples_of_authname">7.17.2. Examples of AUTHNAME</a></li> +</ul> +</li> +<li><a href="#avg_function">7.18. AVG Function</a> +<ul class="sectlevel3"> +<li><a href="#considerations_for_avg">7.18.1. Considerations for AVG</a></li> +</ul> +</li> +<li><a href="#bitand_function">7.19. BITAND Function</a> +<ul class="sectlevel3"> +<li><a href="#considerations_for_bitand">7.19.1. Considerations for BITAND</a></li> +<li><a href="#examples_of_bitand">7.19.2. Examples of BITAND</a></li> +</ul> +</li> +<li><a href="#buffertolob_function">7.20. BUFFERTOLOB Function</a> +<ul class="sectlevel3"> +<li><a href="#buffertolob_function_syntax">7.20.1. Syntax Descriptions of BUFFERTOLOB Function</a></li> +<li><a href="#buffertolob_function_examples">7.20.2. Examples of BUFFERTOLOB Function</a></li> +</ul> +</li> +<li><a href="#case_expression">7.21. CASE (Conditional) Expression</a> <ul class="sectlevel3"> -<li><a href="#examples_of_asin">7.13.1. Examples of ASIN</a></li> +<li><a href="#considerations_for_case">7.21.1. Considerations for CASE</a></li> +<li><a href="#examples_of_case">7.21.2. Examples of CASE</a></li> </ul> </li> -<li><a href="#atan_function">7.14. ATAN Function</a> +<li><a href="#cast_expression">7.22. CAST Expression</a> <ul class="sectlevel3"> -<li><a href="#examples_of_atan">7.14.1. Examples of ATAN</a></li> +<li><a href="#considerations_for_cast">7.22.1. Considerations for CAST</a></li> +<li><a href="#examples_of_cast">7.22.2. Examples of CAST</a></li> </ul> </li> -<li><a href="#atan2_function">7.15. ATAN2 Function</a> +<li><a href="#ceiling_function">7.23. CEILING Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_atan2">7.15.1. Examples of ATAN2</a></li> +<li><a href="#examples_of_ceiling">7.23.1. Examples of CEILING</a></li> +<li><a href="#char_function">7.23.2. CHAR Function</a></li> +<li><a href="#considerations_for_char">7.23.3. Considerations for CHAR</a></li> +<li><a href="#examples_of_char">7.23.4. Examples of CHAR</a></li> </ul> </li> -<li><a href="#authname_function">7.16. AUTHNAME Function</a> +<li><a href="#char_length_function">7.24. CHAR_LENGTH Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_authname">7.16.1. Considerations for AUTHNAME</a></li> -<li><a href="#examples_of_authname">7.16.2. Examples of AUTHNAME</a></li> +<li><a href="#considerations_for_char_length">7.24.1. Considerations for CHAR_LENGTH</a></li> +<li><a href="#examples_of_char_length">7.24.2. Examples of CHAR_LENGTH</a></li> </ul> </li> -<li><a href="#avg_function">7.17. AVG Function</a> +<li><a href="#coalesce_function">7.25. COALESCE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_avg">7.17.1. Considerations for AVG</a></li> +<li><a href="#examples_of_coalesce">7.25.1. Examples of COALESCE</a></li> </ul> </li> -<li><a href="#bitand_function">7.18. BITAND Function</a> +<li><a href="#code_value_function">7.26. CODE_VALUE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_bitand">7.18.1. Considerations for BITAND</a></li> -<li><a href="#examples_of_bitand">7.18.2. Examples of BITAND</a></li> +<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="#case_expression">7.19. CASE (Conditional) Expression</a> +<li><a href="#converttohex_function">7.27. CONVERTTOHEX Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_case">7.19.1. Considerations for CASE</a></li> -<li><a href="#examples_of_case">7.19.2. Examples of CASE</a></li> +<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> </ul> </li> -<li><a href="#cast_expression">7.20. CAST Expression</a> +<li><a href="#converttimestamp_function">7.28. CONVERTTIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_cast">7.20.1. Considerations for CAST</a></li> -<li><a href="#examples_of_cast">7.20.2. Examples of CAST</a></li> +<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> </ul> </li> -<li><a href="#ceiling_function">7.21. CEILING Function</a> +<li><a href="#cos_function">7.29. COS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_ceiling">7.21.1. Examples of CEILING</a></li> -<li><a href="#char_function">7.21.2. CHAR Function</a></li> -<li><a href="#considerations_for_char">7.21.3. Considerations for CHAR</a></li> -<li><a href="#examples_of_char">7.21.4. Examples of CHAR</a></li> +<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> </ul> </li> -<li><a href="#char_length_function">7.22. CHAR_LENGTH Function</a> +<li><a href="#current_function">7.30. CURRENT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_char_length">7.22.1. Considerations for CHAR_LENGTH</a></li> -<li><a href="#examples_of_char_length">7.22.2. Examples of CHAR_LENGTH</a></li> +<li><a href="#examples_of_current">7.30.1. Examples of CURRENT</a></li> </ul> </li> -<li><a href="#coalesce_function">7.23. COALESCE Function</a> +<li><a href="#current_date_function">7.31. CURRENT_DATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_coalesce">7.23.1. Examples of COALESCE</a></li> +<li><a href="#examples_of_current_date">7.31.1. Examples of CURRENT_DATE</a></li> </ul> </li> -<li><a href="#code_value_function">7.24. CODE_VALUE Function</a> +<li><a href="#current_time_function">7.32. CURRENT_TIME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_code_value_function">7.24.1. Examples of CODE_VALUE Function</a></li> -<li><a href="#concat_function">7.24.2. CONCAT Function</a></li> -<li><a href="#concatenation_operator">7.24.3. Concatenation Operator (||)</a></li> -<li><a href="#considerations_for_concat">7.24.4. Considerations for CONCAT</a></li> -<li><a href="#operands">7.24.5. Operands</a></li> -<li><a href="#sql-parameters">7.24.6. SQL Parameters</a></li> -<li><a href="#examples_of_concat">7.24.7. Examples of CONCAT</a></li> +<li><a href="#examples_of_current_time">7.32.1. Examples of CURRENT_TIME</a></li> </ul> </li> -<li><a href="#converttohex_function">7.25. CONVERTTOHEX Function</a> +<li><a href="#current_timestamp_function">7.33. CURRENT_TIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_converttohex">7.25.1. Considerations for CONVERTTOHEX</a></li> -<li><a href="#examples_of_converttohex">7.25.2. Examples of CONVERTTOHEX</a></li> +<li><a href="#examples_of_current_timestamp">7.33.1. Examples of CURRENT_TIMESTAMP</a></li> </ul> </li> -<li><a href="#converttimestamp_function">7.26. CONVERTTIMESTAMP Function</a> +<li><a href="#current_user_function">7.34. CURRENT_USER Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_converttimestamp">7.26.1. Considerations for CONVERTTIMESTAMP</a></li> -<li><a href="#examples_of_converttimestamp">7.26.2. Examples of CONVERTTIMESTAMP</a></li> +<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> </ul> </li> -<li><a href="#cos_function">7.27. COS Function</a> +<li><a href="#date_add_function">7.35. DATE_ADD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_cos">7.27.1. Examples of COS</a></li> -<li><a href="#cosh_function">7.27.2. COSH Function</a></li> -<li><a href="#examples_of_cosh">7.27.3. Examples of COSH</a></li> -<li><a href="#count_function">7.27.4. COUNT Function</a></li> -<li><a href="#considerations_for_count">7.27.5. Considerations for COUNT</a></li> -<li><a href="#examples_of_count">7.27.6. Examples of COUNT</a></li> -<li><a href="#examples_of_crc32">7.27.7. examples of CR32</a></li> +<li><a href="#examples_of_date_add">7.35.1. Examples of DATE_ADD</a></li> </ul> </li> -<li><a href="#current_function">7.28. CURRENT Function</a> +<li><a href="#date_sub_function">7.36. DATE_SUB Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current">7.28.1. Examples of CURRENT</a></li> +<li><a href="#examples_of_date_sub">7.36.1. Examples of DATE_SUB</a></li> </ul> </li> -<li><a href="#current_date_function">7.29. CURRENT_DATE Function</a> +<li><a href="#dateadd_function">7.37. DATEADD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current_date">7.29.1. Examples of CURRENT_DATE</a></li> +<li><a href="#examples_of_dateadd">7.37.1. Examples of DATEADD</a></li> </ul> </li> -<li><a href="#current_time_function">7.30. CURRENT_TIME Function</a> +<li><a href="#datediff_function">7.38. DATEDIFF Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current_time">7.30.1. Examples of CURRENT_TIME</a></li> +<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> </ul> </li> -<li><a href="#current_timestamp_function">7.31. CURRENT_TIMESTAMP Function</a> +<li><a href="#date_part_function_of_an_interval">7.39. DATE_PART Function (of an Interval)</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current_timestamp">7.31.1. Examples of CURRENT_TIMESTAMP</a></li> +<li><a href="#examples_of_date_part">7.39.1. Examples of DATE_PART</a></li> </ul> </li> -<li><a href="#current_user_function">7.32. CURRENT_USER Function</a> +<li><a href="#date_part_function_of_a_timestamp">7.40. DATE_PART Function (of a Timestamp)</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_current_user">7.32.1. Considerations for CURRENT_USER</a></li> -<li><a href="#examples_of_current_user">7.32.2. Examples of CURRENT_USER</a></li> +<li><a href="#examples_of_date_part">7.40.1. Examples of DATE_PART</a></li> </ul> </li> -<li><a href="#date_add_function">7.33. DATE_ADD Function</a> +<li><a href="#date_trunc_function">7.41. DATE_TRUNC Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_add">7.33.1. Examples of DATE_ADD</a></li> +<li><a href="#examples_of_date_trunc">7.41.1. Examples of DATE_TRUNC</a></li> </ul> </li> -<li><a href="#date_sub_function">7.34. DATE_SUB Function</a> +<li><a href="#day_function">7.42. DAY Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_sub">7.34.1. Examples of DATE_SUB</a></li> +<li><a href="#examples_of_day">7.42.1. Examples of Day</a></li> </ul> </li> -<li><a href="#dateadd_function">7.35. DATEADD Function</a> +<li><a href="#dayname_function">7.43. DAYNAME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dateadd">7.35.1. Examples of DATEADD</a></li> +<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> </ul> </li> -<li><a href="#datediff_function">7.36. DATEDIFF Function</a> +<li><a href="#dayofmonth_function">7.44. DAYOFMONTH Function</a> <ul class="sectlevel3"> -<li><a href="#syntax_description_of_datediff">7.36.1. Syntax Description of DATEDIFF</a></li> -<li><a href="#considerations_for_datediff">7.36.2. Considerations for DATEDIFF</a></li> -<li><a href="#examples_of_datediff">7.36.3. Examples of DATEDIFF</a></li> -<li><a href="#date_difference_in_year">7.36.4. Date Difference in YEAR</a></li> -<li><a href="#dateformat_function">7.36.5. DATEFORMAT Function</a></li> -<li><a href="#considerations_for_dateformat">7.36.6. Considerations for DATEFORMAT</a></li> -<li><a href="#examples_of_dateformat">7.36.7. Examples of DATEFORMAT</a></li> +<li><a href="#examples_of_dayofmonth">7.44.1. Examples of DAYOFMONTH</a></li> </ul> </li> -<li><a href="#date_part_function_of_an_interval">7.37. DATE_PART Function (of an Interval)</a> +<li><a href="#dayofweek_function">7.45. DAYOFWEEK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_part">7.37.1. Examples of DATE_PART</a></li> +<li><a href="#examples_of_dayofweek">7.45.1. Examples of DAYOFWEEK</a></li> </ul> </li> -<li><a href="#date_part_function_of_a_timestamp">7.38. DATE_PART Function (of a Timestamp)</a> +<li><a href="#dayofyear_function">7.46. DAYOFYEAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_part">7.38.1. Examples of DATE_PART</a></li> +<li><a href="#examples_of_dayofyear">7.46.1. Examples of DAYOFYEAR</a></li> </ul> </li> -<li><a href="#date_trunc_function">7.39. DATE_TRUNC Function</a> +<li><a href="#Decode_function">7.47. DECODE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_trunc">7.39.1. Examples of DATE_TRUNC</a></li> +<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> </ul> </li> -<li><a href="#day_function">7.40. DAY Function</a> +<li><a href="#degrees_function">7.48. DEGREES Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_day">7.40.1. Examples of Day</a></li> +<li><a href="#examples_of_degrees">7.48.1. Examples of Degrees</a></li> </ul> </li> -<li><a href="#dayname_function">7.41. DAYNAME Function</a> +<li><a href="#diff1_function">7.49. DIFF1 Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_dayname">7.41.1. Considerations for DAYNAME</a></li> -<li><a href="#examples_of_dayname">7.41.2. Examples of DAYNAME</a></li> +<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> </ul> </li> -<li><a href="#dayofmonth_function">7.42. DAYOFMONTH Function</a> +<li><a href="#diff2_function">7.50. DIFF2 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dayofmonth">7.42.1. Examples of DAYOFMONTH</a></li> +<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> </ul> </li> -<li><a href="#dayofweek_function">7.43. DAYOFWEEK Function</a> +<li><a href="#emptyblob_function">7.51. EMPTY_BLOB() Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dayofweek">7.43.1. Examples of DAYOFWEEK</a></li> +<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> </ul> </li> -<li><a href="#dayofyear_function">7.44. DAYOFYEAR Function</a> +<li><a href="#emptyclob_function">7.52. EMPTY_CLOB() Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dayofyear">7.44.1. Examples of DAYOFYEAR</a></li> +<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> </ul> </li> -<li><a href="#Decode_function">7.45. DECODE Function</a> +<li><a href="#exp_function">7.53. EXP Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_decode">7.45.1. Considerations for DECODE</a></li> -<li><a href="#_examples_of_decode">7.45.2. Examples of DECODE</a></li> +<li><a href="#examples_of_exp">7.53.1. Examples of EXP</a></li> </ul> </li> -<li><a href="#degrees_function">7.46. DEGREES Function</a> +<li><a href="#explain_function">7.54. EXPLAIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_degrees">7.46.1. Examples of Degrees</a></li> +<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> </ul> </li> -<li><a href="#diff1_function">7.47. DIFF1 Function</a> +<li><a href="#externaltolob_function">7.55. EXTERNALTOLOB Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_diff1">7.47.1. Considerations for DIFF1</a></li> -<li><a href="#examples_of_diff1">7.47.2. Examples of DIFF1</a></li> +<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> </ul> </li> -<li><a href="#diff2_function">7.48. DIFF2 Function</a> +<li><a href="#extract_function">7.56. EXTRACT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_diff2">7.48.1. Considerations for DIFF2</a></li> -<li><a href="#examples_of_diff2">7.48.2. Examples of DIFF2</a></li> +<li><a href="#examples_of_extract">7.56.1. Examples of EXTRACT</a></li> </ul> </li> -<li><a href="#exp_function">7.49. EXP Function</a> +<li><a href="#filetolob_function">7.57. FILETOLOB Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_exp">7.49.1. Examples of EXP</a></li> +<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> </ul> </li> -<li><a href="#explain_function">7.50. EXPLAIN Function</a> +<li><a href="#group_concat_function">7.58. GROUP_CONCAT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_explain_function">7.50.1. Considerations for EXPLAIN Function</a></li> -<li><a href="#examples_of_explain_function">7.50.2. Examples of EXPLAIN Function</a></li> +<li><a href="#examples_of_group_concat">7.58.1. Examples of GROUP_CONCAT</a></li> </ul> </li> -<li><a href="#extract_function">7.51. EXTRACT Function</a> +<li><a href="#hour_function">7.59. HOUR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_extract">7.51.1. Examples of EXTRACT</a></li> -<li><a href="#hour_function">7.51.2. HOUR Function</a></li> -<li><a href="#examples_of_hour">7.51.3. Examples of HOUR</a></li> +<li><a href="#examples_of_hour">7.59.1. Examples of HOUR</a></li> </ul> </li> -<li><a href="#group_concat_function">7.52. GROUP_CONCAT Function</a> +<li><a href="#insert_function">7.60. INSERT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_group_concat">7.52.1. Examples of GROUP_CONCAT</a></li> +<li><a href="#examples_of_insert">7.60.1. Examples of INSERT</a></li> </ul> </li> -<li><a href="#insert_function">7.53. INSERT Function</a> +<li><a href="#is_ipv4_function">7.61. IS_IPV4 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_insert">7.53.1. Examples of INSERT</a></li> +<li><a href="#examples_of_is_ipv4">7.61.1. Examples of IS_IPV4</a></li> </ul> </li> -<li><a href="#is_ipv4_function">7.54. IS_IPV4 Function</a> +<li><a href="#is_ipv6_function">7.62. IS_IPV6 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_is_ipv4">7.54.1. Examples of IS_IPV4</a></li> +<li><a href="#examples_of_is_ipv6">7.62.1. Examples of IS_IPV6</a></li> </ul> </li> -<li><a href="#is_ipv6_function">7.55. IS_IPV6 Function</a> +<li><a href="#inet_aton_function">7.63. INET_ATON Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_is_ipv6">7.55.1. Examples of IS_IPV6</a></li> +<li><a href="#examples_of_inet_aton">7.63.1. Examples of INET_ATON</a></li> </ul> </li> -<li><a href="#inet_aton_function">7.56. INET_ATON Function</a> +<li><a href="#inet_ntoa_function">7.64. INET_NTOA Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_inet_aton">7.56.1. Examples of INET_ATON</a></li> +<li><a href="#examples_of_inet_ntoa">7.64.1. Examples of INET_NTOA</a></li> </ul> </li> -<li><a href="#inet_ntoa_function">7.57. INET_NTOA Function</a> +<li><a href="#isnull_function">7.65. ISNULL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_inet_ntoa">7.57.1. Examples of INET_NTOA</a></li> +<li><a href="#examples_of_isnull">7.65.1. Examples of ISNULL</a></li> </ul> </li> -<li><a href="#isnull_function">7.58. ISNULL Function</a> +<li><a href="#juliantimestamp_function">7.66. JULIANTIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_isnull">7.58.1. Examples of ISNULL</a></li> +<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> </ul> </li> -<li><a href="#juliantimestamp_function">7.59. JULIANTIMESTAMP Function</a> +<li><a href="#lastnotnull_function">7.67. LASTNOTNULL Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_juliantimestamp">7.59.1. Considerations for JULIANTIMESTAMP</a></li> -<li><a href="#examples_of_juliantimestamp">7.59.2. Examples of JULIANTIMESTAMP</a></li> +<li><a href="#examples_of_lastnotnull">7.67.1. Examples of LASTNOTNULL</a></li> </ul> </li> -<li><a href="#lastnotnull_function">7.60. LASTNOTNULL Function</a> +<li><a href="#lcase_function">7.68. LCASE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lastnotnull">7.60.1. Examples of LASTNOTNULL</a></li> +<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> </ul> </li> -<li><a href="#lcase_function">7.61. LCASE Function</a> +<li><a href="#locate_function">7.69. LOCATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lcase">7.61.1. Examples of LCASE</a></li> -<li><a href="#left_function">7.61.2. LEFT Function</a></li> -<li><a href="#examples_of_left">7.61.3. Examples of LEFT</a></li> +<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> </ul> </li> -<li><a href="#locate_function">7.62. LOCATE Function</a> +<li><a href="#log_function">7.70. LOG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_locate">7.62.1. Considerations for LOCATE</a></li> -<li><a href="#examples_of_locate">7.62.2. Examples of LOCATE</a></li> +<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> </ul> </li> -<li><a href="#log_function">7.63. LOG Function</a> +<li><a href="#lower_function">7.71. LOWER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_log">7.63.1. Examples of LOG</a></li> -<li><a href="#log10_function">7.63.2. LOG10 Function</a></li> -<li><a href="#examples_of_log10">7.63.3. Examples of LOG10</a></li> +<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> </ul> </li> -<li><a href="#lower_function">7.64. LOWER Function</a> +<li><a href="#ltrim_function">7.72. LTRIM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_lower">7.64.1. Considerations for LOWER</a></li> -<li><a href="#examples_of_lower">7.64.2. Examples of LOWER</a></li> -<li><a href="#lpad_function">7.64.3. LPAD Function</a></li> -<li><a href="#examples_of_lpad">7.64.4. Examples of LPAD</a></li> +<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> </ul> </li> -<li><a href="#ltrim_function">7.65. LTRIM Function</a> +<li><a href="#max_function">7.73. MAX/MAXIMUM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ltrim">7.65.1. Considerations for LTRIM</a></li> -<li><a href="#examples_of_ltrim">7.65.2. Examples of LTRIM</a></li> +<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> </ul> </li> -<li><a href="#max_function">7.66. MAX/MAXIMUM Function</a> +<li><a href="#md5_function">7.74. MD5 Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_max">7.66.1. Considerations for MAX/MAXIMUM</a></li> -<li><a href="#operands_of_the_expression">7.66.2. Operands of the Expression</a></li> -<li><a href="#examples_of_max">7.66.3. Examples of MAX/MAXIMUM</a></li> +<li><a href="#examples_of_md5">7.74.1. Examples of MD5</a></li> </ul> </li> -<li><a href="#md5_function">7.67. MD5 Function</a> +<li><a href="#min_function">7.75. MIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_md5">7.67.1. Examples of MD5</a></li> +<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> </ul> </li> -<li><a href="#min_function">7.68. MIN Function</a> +<li><a href="#minute_function">7.76. MINUTE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_min">7.68.1. Considerations for MIN</a></li> -<li><a href="#examples_of_min">7.68.2. Examples of MIN</a></li> +<li><a href="#examples_of_minute">7.76.1. Examples of minute</a></li> </ul> </li> -<li><a href="#minute_function">7.69. MINUTE Function</a> +<li><a href="#mod_function">7.77. MOD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_minute">7.69.1. Examples of minute</a></li> +<li><a href="#examples_of_mod">7.77.1. Examples of MOD</a></li> </ul> </li> -<li><a href="#mod_function">7.70. MOD Function</a> +<li><a href="#month_function">7.78. MONTH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_mod">7.70.1. Examples of MOD</a></li> +<li><a href="#examples_of_month">7.78.1. Examples of MONTH</a></li> </ul> </li> -<li><a href="#month_function">7.71. MONTH Function</a> +<li><a href="#monthname_function">7.79. MONTHNAME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_month">7.71.1. Examples of MONTH</a></li> +<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> </ul> </li> -<li><a href="#monthname_function">7.72. MONTHNAME Function</a> +<li><a href="#movingavg_function">7.80. MOVINGAVG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_monthname">7.72.1. Considerations for MONTHNAME</a></li> -<li><a href="#examples_of_monthname">7.72.2. Examples of MONTHNAME</a></li> +<li><a href="#examples_of_movingavg">7.80.1. Examples of MOVINGAVG</a></li> </ul> </li> -<li><a href="#movingavg_function">7.73. MOVINGAVG Function</a> +<li><a href="#movingcount_function">7.81. MOVINGCOUNT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingavg">7.73.1. Examples of MOVINGAVG</a></li> +<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> </ul> </li> -<li><a href="#movingcount_function">7.74. MOVINGCOUNT Function</a> +<li><a href="#movingmax_function">7.82. MOVINGMAX Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_movingcount">7.74.1. Considerations for MOVINGCOUNT</a></li> -<li><a href="#examples_of_movingcount">7.74.2. Examples of MOVINGCOUNT</a></li> +<li><a href="#examples_of_movingmax">7.82.1. Examples of MOVINGMAX</a></li> </ul> </li> -<li><a href="#movingmax_function">7.75. MOVINGMAX Function</a> +<li><a href="#movingmin_function">7.83. MOVINGMIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingmax">7.75.1. Examples of MOVINGMAX</a></li> +<li><a href="#examples_of_movingmin">7.83.1. Examples of MOVINGMIN</a></li> </ul> </li> -<li><a href="#movingmin_function">7.76. MOVINGMIN Function</a> +<li><a href="#movingstddev_function">7.84. MOVINGSTDDEV Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingmin">7.76.1. Examples of MOVINGMIN</a></li> +<li><a href="#examples_of_movingstddev">7.84.1. Examples of MOVINGSTDDEV</a></li> </ul> </li> -<li><a href="#movingstddev_function">7.77. MOVINGSTDDEV Function</a> +<li><a href="#movingsum_function">7.85. MOVINGSUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingstddev">7.77.1. Examples of MOVINGSTDDEV</a></li> +<li><a href="#examples_of_movingsum">7.85.1. Examples of MOVINGSUM</a></li> </ul> </li> -<li><a href="#movingsum_function">7.78. MOVINGSUM Function</a> +<li><a href="#movingvariance_function">7.86. MOVINGVARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingsum">7.78.1. Examples of MOVINGSUM</a></li> +<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> </ul> </li> -<li><a href="#movingvariance_function">7.79. MOVINGVARIANCE Function</a> +<li><a href="#nullifzero_function">7.87. NULLIFZERO Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingvariance">7.79.1. Examples of MOVINGVARIANCE</a></li> -<li><a href="#nullif_function">7.79.2. NULLIF Function</a></li> -<li><a href="#examples_of_nullif">7.79.3. Examples of NULLIF</a></li> +<li><a href="#examples_of_nullifzero">7.87.1. Examples of NULLIFZERO</a></li> </ul> </li> -<li><a href="#nullifzero_function">7.80. NULLIFZERO Function</a> +<li><a href="#nvl_function">7.88. NVL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_nullifzero">7.80.1. Examples of NULLIFZERO</a></li> +<li><a href="#examples_of_nvl">7.88.1. Examples of NVL</a></li> </ul> </li> -<li><a href="#nvl_function">7.81. NVL Function</a> +<li><a href="#octet_length_function">7.89. OCTET_LENGTH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_nvl">7.81.1. Examples of NVL</a></li> +<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> </ul> </li> -<li><a href="#octet_length_function">7.82. OCTET_LENGTH Function</a> +<li><a href="#pi_function">7.90. PI Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_octet_length">7.82.1. Considerations for OCTET_LENGTH</a></li> -<li><a href="#offset_function">7.82.2. OFFSET Function</a></li> -<li><a href="#examples_of_offset">7.82.3. Examples of OFFSET</a></li> +<li><a href="#examples_of_pi">7.90.1. Examples of PI</a></li> </ul> </li> -<li><a href="#pi_function">7.83. PI Function</a> +<li><a href="#position_function">7.91. POSITION Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_pi">7.83.1. Examples of PI</a></li> +<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> </ul> </li> -<li><a href="#position_function">7.84. POSITION Function</a> +<li><a href="#power_function">7.92. POWER Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_position">7.84.1. Considerations for POSITION</a></li> -<li><a href="#examples_of_position">7.84.2. Examples of POSITION</a></li> +<li><a href="#examples_of_power">7.92.1. Examples of POWER</a></li> </ul> </li> -<li><a href="#power_function">7.85. POWER Function</a> +<li><a href="#quarter_function">7.93. QUARTER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_power">7.85.1. Examples of POWER</a></li> +<li><a href="#examples_of_quarter">7.93.1. Examples of QUARTER</a></li> </ul> </li> -<li><a href="#quarter_function">7.86. QUARTER Function</a> +<li><a href="#radians_function">7.94. RADIANS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_quarter">7.86.1. Examples of QUARTER</a></li> +<li><a href="#examples_of_radians">7.94.1. Examples of RADIANS</a></li> </ul> </li> -<li><a href="#radians_function">7.87. RADIANS Function</a> +<li><a href="#runningrank_function">7.95. RANK/RUNNINGRANK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_radians">7.87.1. Examples of RADIANS</a></li> +<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> </ul> </li> -<li><a href="#runningrank_function">7.88. RANK/RUNNINGRANK Function</a> +<li><a href="#repeat_function">7.96. REPEAT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningrank">7.88.1. Considerations for RANK/RUNNINGRANK</a></li> -<li><a href="#examples_of_runningrank">7.88.2. Examples of RANK/RUNNINGRANK</a></li> +<li><a href="#examples_of_repeat">7.96.1. Examples of REPEAT</a></li> </ul> </li> -<li><a href="#repeat_function">7.89. REPEAT Function</a> +<li><a href="#replace_function">7.97. REPLACE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_repeat">7.89.1. Examples of REPEAT</a></li> +<li><a href="#examples_of_replace">7.97.1. Examples of REPLACE</a></li> </ul> </li> -<li><a href="#replace_function">7.90. REPLACE Function</a> +<li><a href="#right_function">7.98. RIGHT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_replace">7.90.1. Examples of REPLACE</a></li> +<li><a href="#examples_of_right">7.98.1. Examples of RIGHT</a></li> </ul> </li> -<li><a href="#right_function">7.91. RIGHT Function</a> +<li><a href="#round_function">7.99. ROUND Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_right">7.91.1. Examples of RIGHT</a></li> +<li><a href="#examples_of_round">7.99.1. Examples of ROUND</a></li> </ul> </li> -<li><a href="#round_function">7.92. ROUND Function</a> +<li><a href="#rows_since_function">7.100. ROWS SINCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_round">7.92.1. Examples of ROUND</a></li> +<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> </ul> </li> -<li><a href="#rows_since_function">7.93. ROWS SINCE Function</a> +<li><a href="#rows_since_changed_function">7.101. ROWS SINCE CHANGED Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rows_since">7.93.1. Considerations for ROWS SINCE</a></li> -<li><a href="#examples_of_rows_since">7.93.2. Examples of ROWS SINCE</a></li> +<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> </ul> </li> -<li><a href="#rows_since_changed_function">7.94. ROWS SINCE CHANGED Function</a> +<li><a href="#rpad_function">7.102. RPAD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rows_since_changed">7.94.1. Considerations for ROWS SINCE CHANGED</a></li> -<li><a href="#examples_of_rows_since_changed">7.94.2. Examples of ROWS SINCE CHANGED</a></li> +<li><a href="#examples_of_rpad_function">7.102.1. Examples of RPAD Function</a></li> </ul> </li> -<li><a href="#rpad_function">7.95. RPAD Function</a> +<li><a href="#rtrim_function">7.103. RTRIM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_rpad_function">7.95.1. Examples of RPAD Function</a></li> +<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> </ul> </li> -<li><a href="#rtrim_function">7.96. RTRIM Function</a> +<li><a href="#runningavg_function">7.104. RUNNINGAVG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rtrim">7.96.1. Considerations for RTRIM</a></li> -<li><a href="#examples_of_rtrim">7.96.2. Examples of RTRIM</a></li> +<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> </ul> </li> -<li><a href="#runningavg_function">7.97. RUNNINGAVG Function</a> +<li><a href="#runningcount_function">7.105. RUNNINGCOUNT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningavg">7.97.1. Considerations for RUNNINGAVG</a></li> -<li><a href="#examples_of_runningavg">7.97.2. Examples of RUNNINGAVG</a></li> +<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> </ul> </li> -<li><a href="#runningcount_function">7.98. RUNNINGCOUNT Function</a> +<li><a href="#runningmax_function">7.106. RUNNINGMAX Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningcount">7.98.1. Considerations for RUNNINGCOUNT</a></li> -<li><a href="#examples_of_runningcount">7.98.2. Examples of RUNNINGCOUNT</a></li> +<li><a href="#examples_of_runningmax">7.106.1. Examples of RUNNINGMAX</a></li> </ul> </li> -<li><a href="#runningmax_function">7.99. RUNNINGMAX Function</a> +<li><a href="#runningmin_function">7.107. RUNNINGMIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningmax">7.99.1. Examples of RUNNINGMAX</a></li> +<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> </ul> </li> -<li><a href="#runningmin_function">7.100. RUNNINGMIN Function</a> +<li><a href="#runningsum_function">7.108. RUNNINGSUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningmin">7.100.1. Examples of RUNNINGMIN</a></li> -<li><a href="#runningstddev_function">7.100.2. RUNNINGSTDDEV Function</a></li> -<li><a href="#considerations_for_runningstddev">7.100.3. Considerations for RUNNINGSTDDEV</a></li> -<li><a href="#examples_of_runningstddev">7.100.4. Examples of RUNNINGSTDDEV</a></li> +<li><a href="#examples_of_runningsum">7.108.1. Examples of RUNNINGSUM</a></li> </ul> </li> -<li><a href="#runningsum_function">7.101. RUNNINGSUM Function</a> +<li><a href="#runningvariance_function">7.109. RUNNINGVARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningsum">7.101.1. Examples of RUNNINGSUM</a></li> +<li><a href="#examples_of_runningvariance">7.109.1. Examples of RUNNINGVARIANCE</a></li> </ul> </li> -<li><a href="#runningvariance_function">7.102. RUNNINGVARIANCE Function</a> +<li><a href="#second_function">7.110. SECOND Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningvariance">7.102.1. Examples of RUNNINGVARIANCE</a></li> +<li><a href="#examples_of_second">7.110.1. Examples of SECOND</a></li> </ul> </li> -<li><a href="#second_function">7.103. SECOND Function</a> +<li><a href="#sha_function">7.111. SHA Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_second">7.103.1. Examples of SECOND</a></li> +<li><a href="#examples_of_sha">7.111.1. examples of SHA</a></li> </ul> </li> -<li><a href="#sha_function">7.104. SHA Function</a> +<li><a href="#sha2_function">7.112. SHA2 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sha">7.104.1. examples of SHA</a></li> +<li><a href="#examples_of_sha2">7.112.1. examples of SHA2</a></li> </ul> </li> -<li><a href="#sha2_function">7.105. SHA2 Function</a> +<li><a href="#sign_function">7.113. SIGN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sha2">7.105.1. examples of SHA2</a></li> +<li><a href="#examples_of_sign">7.113.1. Examples of SIGN</a></li> </ul> </li> -<li><a href="#sign_function">7.106. SIGN Function</a> +<li><a href="#sin_function">7.114. SIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sign">7.106.1. Examples of SIGN</a></li> +<li><a href="#examples_of_sin">7.114.1. Examples of SIN</a></li> </ul> </li> -<li><a href="#sin_function">7.107. SIN Function</a> +<li><a href="#sinh_function">7.115. SINH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sin">7.107.1. Examples of SIN</a></li> +<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> </ul> </li> -<li><a href="#sinh_function">7.108. SINH Function</a> +<li><a href="#sqrt_function">7.116. SQRT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sinh">7.108.1. Examples of SINH</a></li> -<li><a href="#space_function">7.108.2. SPACE Function</a></li> -<li><a href="#examples_of_space">7.108.3. Examples of SPACE</a></li> +<li><a href="#examples_of_sqrt">7.116.1. Examples of SQRT</a></li> </ul> </li> -<li><a href="#sqrt_function">7.109. SQRT Function</a> +<li><a href="#stddev_function">7.117. STDDEV Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sqrt">7.109.1. Examples of SQRT</a></li> +<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> </ul> </li> -<li><a href="#stddev_function">7.110. STDDEV Function</a> +<li><a href="#stringtolob_function">7.118. STRINGTOLOB Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_stddev">7.110.1. Considerations for STDDEV</a></li> -<li><a href="#examples_of_stddev">7.110.2. Examples of STDDEV</a></li> +<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> </ul> </li> -<li><a href="#substring_function">7.111. SUBSTRING/SUBSTR Function</a> +<li><a href="#substring_function">7.119. SUBSTRING/SUBSTR Function</a> <ul class="sectlevel3"> -<li><a href="#alternative_forms">7.111.1. Alternative Forms</a></li> -<li><a href="#considerations_for_substring">7.111.2. Considerations for SUBSTRING/SUBSTR</a></li> -<li><a href="#examples_of_substring">7.111.3. Examples of SUBSTRING/SUBSTR</a></li> +<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> </ul> </li> -<li><a href="#sum_function">7.112. SUM Function</a> +<li><a href="#sum_function">7.120. SUM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_sum">7.112.1. Considerations for SUM</a></li> -<li><a href="#examples_of_sum">7.112.2. Examples of SUM</a></li> +<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> </ul> </li> -<li><a href="#tan_function">7.113. TAN Function</a> +<li><a href="#tan_function">7.121. TAN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_tan">7.113.1. Examples of TAN</a></li> -<li><a href="#tanh_function">7.113.2. TANH Function</a></li> -<li><a href="#examples_of_tanh">7.113.3. Examples of TANH</a></li> +<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> </ul> </li> -<li><a href="#this_function">7.114. THIS Function</a> +<li><a href="#this_function">7.122. THIS Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_this">7.114.1. Considerations for THIS</a></li> -<li><a href="#examples_of_this">7.114.2. Examples of THIS</a></li> +<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> </ul> </li> -<li><a href="#timestampadd_function">7.115. TIMESTAMPADD Function</a> +<li><a href="#timestampadd_function">7.123. TIMESTAMPADD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampadd">7.115.1. Examples of TIMESTAMPADD</a></li> +<li><a href="#examples_of_timestampadd">7.123.1. Examples of TIMESTAMPADD</a></li> </ul> </li> -<li><a href="#timestampdiff_function">7.116. TIMESTAMPDIFF Function</a> +<li><a href="#timestampdiff_function">7.124. TIMESTAMPDIFF Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampdiff">7.116.1. Examples of TIMESTAMPDIFF</a></li> +<li><a href="#examples_of_timestampdiff">7.124.1. Examples of TIMESTAMPDIFF</a></li> </ul> </li> -<li><a href="#to_char_function">7.117. TO_CHAR Function</a> +<li><a href="#to_char_function">7.125. TO_CHAR Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_to_char">7.117.1. Considerations for TO_CHAR</a></li> -<li><a href="#examples_of_to_char">7.117.2. Examples of TO_CHAR</a></li> +<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> </ul> </li> -<li><a href="#to_date_function">7.118. TO_DATE Function</a> +<li><a href="#to_date_function">7.126. TO_DATE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_to_date">7.118.1. Considerations for TO_DATE</a></li> -<li><a href="#examples_of_to_date">7.118.2. Examples of TO_DATE</a></li> +<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> </ul> </li> -<li><a href="#to_time_function">7.119. TO_TIME Function</a> +<li><a href="#to_time_function">7.127. TO_TIME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_time">7.119.1. Examples of TO_TIME</a></li> +<li><a href="#examples_of_to_time">7.127.1. Examples of TO_TIME</a></li> </ul> </li> -<li><a href="#to_timestamp_function">7.120. TO_TIMESTAMP Function</a> +<li><a href="#to_timestamp_function">7.128. TO_TIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_timestamp">7.120.1. Example of TO_TIMESTAMP</a></li> +<li><a href="#examples_of_to_timestamp">7.128.1. Example of TO_TIMESTAMP</a></li> </ul> </li> -<li><a href="#translate_function">7.121. TRANSLATE Function</a></li> -<li><a href="#trim_function">7.122. TRIM Function</a> +<li><a href="#translate_function">7.129. TRANSLATE Function</a></li> +<li><a href="#trim_function">7.130. TRIM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_trim">7.122.1. Considerations for TRIM</a></li> -<li><a href="#examples_of_trim">7.122.2. Examples of TRIM</a></li> +<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> </ul> </li> -<li><a href="#ucase_function">7.123. UCASE Function</a> +<li><a href="#ucase_function">7.131. UCASE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ucase">7.123.1. Considerations for UCASE</a></li> -<li><a href="#examples_of_ucase">7.123.2. Examples of UCASE</a></li> -<li><a href="#upper_function">7.123.3. UPPER Function</a></li> -<li><a href="#examples_of_upper">7.123.4. Examples of UPPER</a></li> -<li><a href="#upshift_function">7.123.5. UPSHIFT Function</a></li> -<li><a href="#examples_of_upshift">7.123.6. Examples of UPSHIFT</a></li> +<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> </ul> </li> -<li><a href="#user_function">7.124. USER Function</a> +<li><a href="#user_function">7.132. USER Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_user">7.124.1. Considerations for USER</a></li> -<li><a href="#examples_of_user">7.124.2. Examples of USER</a></li> +<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> </ul> </li> -<li><a href="#variance_function">7.125. VARIANCE Function</a> +<li><a href="#variance_function">7.133. VARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_variance">7.125.1. Considerations for VARIANCE</a></li> -<li><a href="#examples_of_variance">7.125.2. Examples of VARIANCE</a></li> +<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> </ul> </li> -<li><a href="#week_function">7.126. WEEK Function</a> +<li><a href="#week_function">7.134. WEEK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_week">7.126.1. Examples of WEEK</a></li> +<li><a href="#examples_of_week">7.134.1. Examples of WEEK</a></li> </ul> </li> -<li><a href="#year_function">7.127. YEAR Function</a> +<li><a href="#year_function">7.135. YEAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_year">7.127.1. Examples of YEAR</a></li> +<li><a href="#examples_of_year">7.135.1. Examples of YEAR</a></li> </ul> </li> -<li><a href="#zeroifnull_function">7.128. ZEROIFNULL Function</a> +<li><a href="#zeroifnull_function">7.136. ZEROIFNULL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_zeroifnull">7.128.1. Examples of ZEROIFNULL</a></li> +<li><a href="#examples_of_zeroifnull">7.136.1. Examples of ZEROIFNULL</a></li> </ul> </li> </ul> @@ -4096,6 +4139,8 @@ data-type is: | time [(time-precision)] | timestamp [(timestamp-precision)] | interval { start-field to end-field | single-field } + | blob [({numeric literal} [unit])] [STORAGE 'storage literal'] + | clob [({numeric literal} [unit])] [STORAGE 'storage literal'] default is: literal @@ -19961,6 +20006,11 @@ unique names within a given schema.</p> hours, minutes, seconds, and fractions of a second).</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#LOB Data Types">LOB Data Types</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">A set of large object data types used to store large volumes of data, +provides random and piece-wise access to the data, such as BLOB and CLOB.</p></td> +</tr> +<tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#numeric_data_types_">Numeric Data Types</a></p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Exact and approximate numeric data types.</p></td> </tr> @@ -20101,6 +20151,18 @@ in which n is the number of significant digits (default is 6; minimum is 1; maxi stored in 2, 4, or 8 bytes depending on number of digits<sup>2</sup></p></td> </tr> <tr> +<td class="tableblock halign-left valign-top" rowspan="2"><p class="tableblock">LOB Data Types</p></td> +<td class="tableblock halign-left valign-top" rowspan="2"><p class="tableblock">LOB</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">BLOB</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Binary Large Object</p></td> +<td class="tableblock halign-left valign-top" rowspan="2"><p class="tableblock">10G â no limit<br> +Currently the limit defaults to 10G. This limit can be configured as needed using the CQD <code>LOB_MAX_SIZE</code>.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">CLOB</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Character Large Object</p></td> +</tr> +<tr> <td class="tableblock halign-left valign-top" rowspan="10"><p class="tableblock">Numeric Data Types</p></td> <td class="tableblock halign-left valign-top" rowspan="5"><p class="tableblock">Numeric</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">NUMERIC (1,<em>scale</em>) to + NUMERIC (128,<em>scale</em>)</p></td> @@ -28593,7 +28655,57 @@ corresponding week of the year.</p></td> </div> </div> <div class="sect2"> -<h3 id="mathematical_functions">7.5. Mathematical Functions</h3> +<h3 id="lob_functions">7.5. LOB Functions</h3> +<div class="paragraph"> +<p>Trafodion provides following LOB functions to process LOB data.</p> +</div> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 25%;"> +<col style="width: 75%;"> +</colgroup> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#emptyblob_function">EMPTY_BLOB() Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Creates a dummy LOB handle of type BLOB.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#emptyclob_function">EMPTY_CLOB() Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Creates a dummy LOB handle of type CLOB.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#stringtolob_function">STRINGTOLOB Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Converts a simple string literal into LOB format.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#filetolob_function">FILETOLOB Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Converts data from a local linux/hdfs file into LOB format.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#buffertolob_function">BUFFERTOLOB_Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Takes the address and size of an input buffer, and converts the contents of that buffer into LOB format.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#externaltolob_function">EXTERNALTOLOB_Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Converts data from an external file into LOB format.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">LOBTOSTRING</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Converts LOB data into a simple string literal.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">LOBTOFILE</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Converts LOB data into a linux/hdfs file.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">LOBTOBUFFER</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Converts LOB data into a buffer.</p></td> +</tr> +</tbody> +</table> +</div> +<div class="sect2"> +<h3 id="mathematical_functions">7.6. Mathematical Functions</h3> <div class="paragraph"> <p>Use these mathematical functions within an SQL numeric value expression:</p> </div> @@ -28719,7 +28831,7 @@ returns 0. If value is greater than zero, returns 1.</p></td> </div> </div> <div class="sect2"> -<h3 id="encryption_functions">7.6. Encryption Functions</h3> +<h3 id="encryption_functions">7.7. Encryption Functions</h3> <div class="paragraph"> <p>Use these functions within an SQL value expression to do data encryption or hashing:</p> </div> @@ -28745,7 +28857,7 @@ returns 0. If value is greater than zero, returns 1.</p></td> </table> </div> <div class="sect2"> -<h3 id="sequence_functions">7.7. Sequence Functions</h3> +<h3 id="sequence_functions">7.8. Sequence Functions</h3> <div class="paragraph"> <p>Sequence functions operate on ordered rows of the intermediate result table of a SELECT statement that includes a SEQUENCE BY clause. Sequence @@ -28762,7 +28874,7 @@ sorted result set must be available to compute the result of the sequence function.</p> </div> <div class="sect3"> -<h4 id="difference_sequence_functions">7.7.1. Difference sequence functions</h4> +<h4 id="difference_sequence_functions">7.8.1. Difference sequence functions</h4> <table class="tableblock frame-all grid-all spread"> <colgroup> <col style="width: 25%;"> @@ -28781,7 +28893,7 @@ sequence function.</p> </table> </div> <div class="sect3"> -<h4 id="moving_sequence_functions">7.7.2. Moving sequence functions</h4> +<h4 id="moving_sequence_functions">7.8.2. Moving sequence functions</h4> <table class="tableblock frame-all grid-all spread"> <colgroup> <col style="width: 25%;"> @@ -28833,7 +28945,7 @@ sequence function.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="running_sequence_functions">7.7.3. Running sequence functions</h4> +<h4 id="running_sequence_functions">7.8.3. Running sequence functions</h4> <table class="tableblock frame-all grid-all spread"> <colgroup> <col style="width: 25%;"> @@ -28876,7 +28988,7 @@ sequence function.</p> </table> </div> <div class="sect3"> -<h4 id="other_sequence_functions">7.7.4. Other sequence functions</h4> +<h4 id="other_sequence_functions">7.8.4. Other sequence functions</h4> <table class="tableblock frame-all grid-all spread"> <colgroup> <col style="width: 25%;"> @@ -28908,7 +29020,7 @@ sequence function.</p> </div> </div> <div class="sect2"> -<h3 id="other_functions_and_expressions">7.8. Other Functions and Expressions</h3> +<h3 id="other_functions_and_expressions">7.9. Other Functions and Expressions</h3> <div class="paragraph"> <p>Use these other functions and expressions in an SQL value expression:</p> </div> @@ -28996,7 +29108,7 @@ associated with the specified user ID number.</p></td> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="abs_function">7.9. ABS Function</h3> +<h3 id="abs_function">7.10. ABS Function</h3> <div class="paragraph"> <p>The ABS function returns the absolute value of a numeric value expression. ABS is a Trafodion SQL extension.</p> @@ -29021,7 +29133,7 @@ LARGEINT if the precision of the argument is greater than or equal to </ul> </div> <div class="sect3"> -<h4 id="examples_of_abs">7.9.1. Examples of ABS</h4> +<h4 id="examples_of_abs">7.10.1. Examples of ABS</h4> <div class="ulist"> <ul> <li> @@ -29038,7 +29150,7 @@ LARGEINT if the precision of the argument is greater than or equal to </div> </div> <div class="sect2"> -<h3 id="acos_function">7.10. ACOS Function</h3> +<h3 id="acos_function">7.11. ACOS Function</h3> <div class="paragraph"> <p>The ACOS function returns the arccosine of a numeric value expression as an angle expressed in radians.</p> @@ -29064,7 +29176,7 @@ from -1 to +1. See <a href="#numeric_value_expressions">Numeric Value_Expression </ul> </div> <div class="sect3"> -<h4 id="examples_of_acos">7.10.1. Examples of ACOS</h4> +<h4 id="examples_of_acos">7.11.1. Examples of ACOS</h4> <div class="ulist"> <ul> <li> @@ -29090,7 +29202,7 @@ inverse of the function COS.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="add_months_function">7.10.2. ADD_MONTHS Function</h4> +<h4 id="add_months_function">7.11.2. ADD_MONTHS Function</h4> <div class="paragraph"> <p>The ADD_MONTHS function adds the integer number of months specified by <em>int_expr</em> to <em>datetime_expr</em> and normalizes the result. ADD_MONTHS is a Trafodion SQL @@ -29136,7 +29248,7 @@ value) is set to the last valid day of the result month. See <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="examples_of_add_months">7.10.3. Examples of ADD_MONTHS</h4> +<h4 id="examples_of_add_months">7.11.3. Examples of ADD_MONTHS</h4> <div class="ulist"> <ul> <li> @@ -29177,7 +29289,7 @@ value) is set to the last valid day of the result month. See </div> </div> <div class="sect2"> -<h3 id="ascii_function">7.11. ASCII Function</h3> +<h3 id="ascii_function">7.12. ASCII Function</h3> <div class="paragraph"> <p>The ASCII function returns the integer that is the ASCII code of the first character in a character string expression associated with either @@ -29203,7 +29315,7 @@ characters. See <a href="#character_value_expressions">Character Value Expressio </ul> </div> <div class="sect3"> -<h4 id="considerations_for_ascii">7.11.1. Considerations For ASCII</h4> +<h4 id="considerations_for_ascii">7.12.1. Considerations For ASCII</h4> <div class="paragraph"> <p>For a string expression in the UTF8 character set, if the value of the first byte in the string is greater than 127, Trafodion SQL returns this @@ -29216,7 +29328,7 @@ error message:</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_ascii">7.11.2. Examples of ASCII</h4> +<h4 id="examples_of_ascii">7.12.2. Examples of ASCII</h4> <div class="ulist"> <ul> <li> @@ -29244,7 +29356,7 @@ SALESREP 83 </div> </div> <div class="sect2"> -<h3 id="asin_function">7.12. ASIN Function</h3> +<h3 id="asin_function">7.13. ASIN Function</h3> <div class="paragraph"> <p>The ASIN function returns the arcsine of a numeric value expression as an angle expressed in radians.</p> @@ -29270,7 +29382,7 @@ from -1 to +1. See <a href="#numeric_value_expressions">Numeric Value Expression </ul> </div> <div class="sect3"> -<h4 id="considerations_for_ascii">7.12.1. Considerations for ASCII</h4> +<h4 id="considerations_for_ascii">7.13.1. Considerations for ASCII</h4> <div class="paragraph"> <p>For a string expression in the UTF8 character set, if the value of the first byte in the string is greater than 127, Trafodion SQL returns this @@ -29283,7 +29395,7 @@ error message:</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_ascii">7.12.2. Examples of ASCII</h4> +<h4 id="examples_of_ascii">7.13.2. Examples of ASCII</h4> <div class="ulist"> <ul> <li> @@ -29311,7 +29423,7 @@ SALESREP 83 </div> </div> <div class="sect2"> -<h3 id="asin_function">7.13. ASIN Function</h3> +<h3 id="asin_function">7.14. ASIN Function</h3> <div class="paragraph"> <p>The ASIN function returns the arcsine of a numeric value expression as an angle expressed in radians.</p> @@ -29337,7 +29449,7 @@ is from -1 to +1. See <a href="#numeric_value_expressions">Numeric Value Express </ul> </div> <div class="sect3"> -<h4 id="examples_of_asin">7.13.1. Examples of ASIN</h4> +<h4 id="examples_of_asin">7.14.1. Examples of ASIN</h4> <div class="ulist"> <ul> <li> @@ -29364,7 +29476,7 @@ inverse of the function SIN.</p> </div> </div> <div class="sect2"> -<h3 id="atan_function">7.14. ATAN Function</h3> +<h3 id="atan_function">7.15. ATAN Function</h3> <div class="paragraph"> <p>The ATAN function returns the arctangent of a numeric value expression as an angle expressed in radians.</p> @@ -29389,7 +29501,7 @@ as an angle expressed in radians.</p> argument of the atan function. See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </div> <div class="sect3"> -<h4 id="examples_of_atan">7.14.1. Examples of ATAN</h4> +<h4 id="examples_of_atan">7.15.1. Examples of ATAN</h4> <div class="ulist"> <ul> <li> @@ -29416,7 +29528,7 @@ inverse of the function TAN.</p> </div> </div> <div class="sect2"> -<h3 id="atan2_function">7.15. ATAN2 Function</h3> +<h3 id="atan2_function">7.16. ATAN2 Function</h3> <div class="paragraph"> <p>The ATAN2 function returns the arctangent of the x and y coordinates, specified by two numeric value expressions, as an angle expressed in @@ -29443,7 +29555,7 @@ coordinate arguments of the ATAN2 function. See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </div> <div class="sect3"> -<h4 id="examples_of_atan2">7.15.1. Examples of ATAN2</h4> +<h4 id="examples_of_atan2">7.16.1. Examples of ATAN2</h4> <div class="ulist"> <ul> <li> @@ -29461,7 +29573,7 @@ approximately 2.6634:</p> </div> </div> <div class="sect2"> -<h3 id="authname_function">7.16. AUTHNAME Function</h3> +<h3 id="authname_function">7.17. AUTHNAME Function</h3> <div class="paragraph"> <p>The AUTHNAME function returns the name of the authorization ID that is associated with the specified authorization ID number.</p> @@ -29486,7 +29598,7 @@ associated with the specified authorization ID number.</p> <p>The AUTHNAME function is similar to the <a href="#user function">USER Function</a>.</p> </div> <div class="sect3"> -<h4 id="considerations_for_authname">7.16.1. Considerations for AUTHNAME</h4> +<h4 id="considerations_for_authname">7.17.1. Considerations for AUTHNAME</h4> <div class="ulist"> <ul> <li> @@ -29499,7 +29611,7 @@ associated with the specified authorization ID number.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_authname">7.16.2. Examples of AUTHNAME</h4> +<h4 id="examples_of_authname">7.17.2. Examples of AUTHNAME</h4> <div class="ulist"> <ul> <li> @@ -29523,7 +29635,7 @@ DB ROOT </div> </div> <div class="sect2"> -<h3 id="avg_function">7.17. AVG Function</h3> +<h3 id="avg_function">7.18. AVG Function</h3> <div class="paragraph"> <p>AVG is an aggregate function that returns the average of a set of numbers.</p> @@ -29561,7 +29673,7 @@ evaluation of <em>expression</em>.</p> <a href="#interval_value_expressions">Interval Value Expressions</a>.</p> </div> <div class="sect3"> -<h4 id="considerations_for_avg">7.17.1. Considerations for AVG</h4> +<h4 id="considerations_for_avg">7.18.1. Considerations for AVG</h4> <div class="sect4"> <h5 id="data-type-of-the-result">Data Type of the Result</h5> <div class="paragraph"> @@ -29655,7 +29767,7 @@ Dept/Num "AVERAGE SALARY" </div> </div> <div class="sect2"> -<h3 id="bitand_function">7.18. BITAND Function</h3> +<h3 id="bitand_function">7.19. BITAND Function</h3> <div class="paragraph"> <p>The BITAND function performs an AND operation on corresponding bits of the two operands. If both bits are 1, the result bit is 1. Otherwise the @@ -29689,7 +29801,7 @@ before performing the bit operation.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_bitand">7.18.1. Considerations for BITAND</h4> +<h4 id="considerations_for_bitand">7.19.1. Considerations for BITAND</h4> <div class="paragraph"> <p>BITAND can be used anywhere in an SQL query where an expression could be used. This includes SELECT lists, WHERE predicates, VALUES clauses, SET @@ -29731,7 +29843,7 @@ types are allowed with the exceptions listed in the </div> </div> <div class="sect3"> -<h4 id="examples_of_bitand">7.18.2. Examples of BITAND</h4> +<h4 id="examples_of_bitand">7.19.2. Examples of BITAND</h4> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">>>select bitand(1,3) from (values(1)) x(a); @@ -29763,7 +29875,67 @@ types are allowed with the exceptions listed in the </div> </div> <div class="sect2"> -<h3 id="case_expression">7.19. CASE (Conditional) Expression</h3> +<h3 id="buffertolob_function">7.20. BUFFERTOLOB Function</h3> +<div class="sect3"> +<h4 id="buffertolob_function_syntax">7.20.1. Syntax Descriptions of BUFFERTOLOB Function</h4> +<div class="paragraph"> +<p>The BUFFERTOLOB function takes the address and size of an input buffer, and converts the contents of that buffer into LOB. This function can be used in an INSERT or UPDATE statement.</p> +</div> +<div class="paragraph"> +<p>BUFFERTOLOB function is a Trafodion SQL extension.</p> +</div> +<div class="paragraph"> +<p>For more information, see <a href="http://trafodion.incubator.apache.org/docs/lob_guide/index.html";>Trafodion SQL Large Objects Guide</a>.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">BUFFERTOLOB(LOCATION lob source buffer address, LENGTH lob length value)</code></pre> +</div> +</div> +<div class="ulist"> +<ul> +<li> +<p><em>lob source buffer address</em></p> +<div class="paragraph"> +<p>The int64 value of the user buffer address.</p> +</div> +</li> +<li> +<p><em>lob length value</em></p> +<div class="paragraph"> +<p>The int64 value of the user specified lob buffer.</p> +</div> +</li> +</ul> +</div> +</div> +<div class="sect3"> +<h4 id="buffertolob_function_examples">7.20.2. Examples of BUFFERTOLOB Function</h4> +<div class="ulist"> +<ul> +<li> +<p>This example takes an int64 value as an input which is an address to a buffer and a size parameter. The buffer contents are converted to LOB format and stored in HDFS.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">insert into tlob1 values (1, buffertolob(LOCATION 124647474, SIZE 2048));</code></pre> +</div> +</div> +</li> +<li> +<p>In the table tlob1, this example updates (overwrites) the c2 to the buffer location at 1254674 with 4000-byte length.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">update tlob1 set c2=buffertolob(LOCATION 12546474, SIZE 4000);</code></pre> +</div> +</div> +</li> +</ul> +</div> +<div style="page-break-after: always;"></div> +</div> +</div> +<div class="sect2"> +<h3 id="case_expression">7.21. CASE (Conditional) Expression</h3> <div class="paragraph"> <p>The CASE expression is a conditional expression with two forms: simple and searched.</p> @@ -29865,7 +30037,7 @@ expression specified in the ELSE clause, or NULL if the ELSE value is not specified.</p> </div> <div class="sect3"> -<h4 id="considerations_for_case">7.19.1. Considerations for CASE</h4> +<h4 id="considerations_for_case">7.21.1. Considerations for CASE</h4> <div class="sect4"> <h5 id="data_type_of_the_case_expression">Data Type of the CASE Expression</h5> <div class="paragraph"> @@ -29927,7 +30099,7 @@ end fields of the result expressions.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_case">7.19.2. Examples of CASE</h4> +<h4 id="examples_of_case">7.21.2. Examples of CASE</h4> <div class="ulist"> <ul> <li> @@ -30002,7 +30174,7 @@ RAYMOND JANE 3000 136000.0000 </div> </div> <div class="sect2"> -<h3 id="cast_expression">7.20. CAST Expression</h3> +<h3 id="cast_expression">7.22. CAST Expression</h3> <div class="paragraph"> <p>The CAST expression converts data to the data type you specify.</p> </div> @@ -30044,7 +30216,7 @@ you must specify the length of the target value.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_cast">7.20.1. Considerations for CAST</h4> +<h4 id="considerations_for_cast">7.22.1. Considerations for CAST</h4> <div class="ulist"> <ul> <li> @@ -30107,7 +30279,7 @@ to another day-time INTERVAL with a different start field precision.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_cast">7.20.2. Examples of CAST</h4> +<h4 id="examples_of_cast">7.22.2. Examples of CAST</h4> <div class="ulist"> <ul> <li> @@ -30144,7 +30316,7 @@ VALUES (001, 'User JBrook, executed at ' || CAST (CURRENT_TIMESTAMP AS CHAR(26)) </div> </div> <div class="sect2"> -<h3 id="ceiling_function">7.21. CEILING Function</h3> +<h3 id="ceiling_function">7.23. CEILING Function</h3> <div class="paragraph"> <p>The CEILING function returns the smallest integer, represented as a FLOAT data type, greater than or equal to a numeric value expression.</p> @@ -30170,7 +30342,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_ceiling">7.21.1. Examples of CEILING</h4> +<h4 id="examples_of_ceiling">7.23.1. Examples of CEILING</h4> <div class="ulist"> <ul> <li> @@ -30187,7 +30359,7 @@ represented as a FLOAT data type:</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="char_function">7.21.2. CHAR Function</h4> +<h4 id="char_function">7.23.2. CHAR Function</h4> <div class="paragraph"> <p>The CHAR function returns the character that has the specified code value, which must be of exact numeric with scale 0.</p> @@ -30222,7 +30394,7 @@ the character set specified by <em>char-set-name</em>.</p> </div> </div> <div class="sect3"> -<h4 id="considerations_for_char">7.21.3. Considerations for CHAR</h4> +<h4 id="considerations_for_char">7.23.3. Considerations for CHAR</h4> <div class="ulist"> <ul> <li> @@ -30235,7 +30407,7 @@ the character set specified by <em>char-set-name</em>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_char">7.21.4. Examples of CHAR</h4> +<h4 id="examples_of_char">7.23.4. Examples of CHAR</h4> <div class="ulist"> <ul> <li> @@ -30264,7 +30436,7 @@ PREMIER INSURANCE 80 P </div> </div> <div class="sect2"> -<h3 id="char_length_function">7.22. CHAR_LENGTH Function</h3> +<h3 id="char_length_function">7.24. CHAR_LENGTH Function</h3> <div class="paragraph"> <p>The CHAR_LENGTH function returns the number of characters in a string. You can also use CHARACTER_LENGTH. Every character, including multi-byte @@ -30290,7 +30462,7 @@ null. See <a href="#character_value_expressions">Character Value Expressions</a> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_char_length">7.22.1. Considerations for CHAR_LENGTH</h4> +<h4 id="considerations_for_char_length">7.24.1. Considerations for CHAR_LENGTH</h4> <div class="sect4"> <h5 id="char_and_varchar_operands">CHAR and VARCHAR Operands</h5> <div class="paragraph"> @@ -30301,7 +30473,7 @@ actual length of the string stored in that column.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_char_length">7.22.2. Examples of CHAR_LENGTH</h4> +<h4 id="examples_of_char_length">7.24.2. Examples of CHAR_LENGTH</h4> <div class="ulist"> <ul> <li> @@ -30358,7 +30530,7 @@ shorter strings — because it is a VARCHAR value:</p> </div> </div> <div class="sect2"> -<h3 id="coalesce_function">7.23. COALESCE Function</h3> +<h3 id="coalesce_function">7.25. COALESCE Function</h3> <div class="paragraph"> <p>The COALESCE function returns the value of the first expression in the list that does not have a NULL value or if all the expressions have NULL @@ -30386,7 +30558,7 @@ values, the function returns a NULL value.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_coalesce">7.23.1. Examples of COALESCE</h4> +<h4 id="examples_of_coalesce">7.25.1. Examples of COALESCE</h4> <div class="ulist"> <ul> <li> @@ -30404,7 +30576,7 @@ from emptbl;</code></pre> </div> </div> <div class="sect2"> -<h3 id="code_value_function">7.24. CODE_VALUE Function</h3> +<h3 id="code_value_function">7.26. CODE_VALUE Function</h3> <div class="paragraph"> <p>The CODE_VALUE function returns an unsigned integer (INTEGER UNSIGNED) that is the code point of the first character in a character value @@ -30431,7 +30603,7 @@ sets.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_code_value_function">7.24.1. Examples of CODE_VALUE Function</h4> +<h4 id="examples_of_code_value_function">7.26.1. Examples of CODE_VALUE Function</h4> <div class="ulist"> <ul> <li> @@ -30451,7 +30623,7 @@ sets.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="concat_function">7.24.2. CONCAT Function</h4> +<h4 id="concat_function">7.26.2. CONCAT Function</h4> <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 @@ -30484,7 +30656,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p> </div> </div> <div class="sect3"> -<h4 id="concatenation_operator">7.24.3. Concatenation Operator (||)</h4> +<h4 id="concatenation_operator">7.26.3. 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 @@ -30501,11 +30673,11 @@ bars (\|\|):</p> </div> </div> <div class="sect3"> -<h4 id="considerations_for_concat">7.24.4. Considerations for CONCAT</h4> +<h4 id="considerations_for_concat">7.26.4. Considerations for CONCAT</h4> </div> <div class="sect3"> -<h4 id="operands">7.24.5. Operands</h4> +<h4 id="operands">7.26.5. Operands</h4> <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 @@ -30518,7 +30690,7 @@ VARCHAR.</p> </div> </div> <div class="sect3"> -<h4 id="sql-parameters">7.24.6. SQL Parameters</h4> +<h4 id="sql-parameters">7.26.6. SQL Parameters</h4> <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 @@ -30547,7 +30719,7 @@ concatenation is 5 March 2002.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_concat">7.24.7. Examples of CONCAT</h4> +<h4 id="examples_of_concat">7.26.7. Examples of CONCAT</h4> <div class="ulist"> <ul> <li> @@ -30575,7 +30747,7 @@ VALUES (002, 'Executed at ' || CAST (CURRENT_TIMESTAMP AS CHAR(26)));</code></pr </div> </div> <div class="sect2"> -<h3 id="converttohex_function">7.25. CONVERTTOHEX Function</h3> +<h3 id="converttohex_function">7.27. CONVERTTOHEX Function</h3> <div class="paragraph"> <p>The CONVERTTOHEX function converts the specified value expression to hexadecimal for display purposes.</p> @@ -30602,7 +30774,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.25.1. Considerations for CONVERTTOHEX</h4> +<h4 id="considerations_for_converttohex">7.27.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 @@ -30615,7 +30787,7 @@ future releases.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="examples_of_converttohex">7.25.2. Examples of CONVERTTOHEX</h4> +<h4 id="examples_of_converttohex">7.27.2. Examples of CONVERTTOHEX</h4> <div class="ulist"> <ul> <li> @@ -30698,7 +30870,7 @@ SELECT CONVERTTOHEX(IV1), CONVERTTOHEX(IV2), CONVERTTOHEX(IV3) from IVT; </div> </div> <div class="sect2"> -<h3 id="converttimestamp_function">7.26. CONVERTTIMESTAMP Function</h3> +<h3 id="converttimestamp_function">7.28. CONVERTTIMESTAMP Function</h3> <div class="paragraph"> <p>The CONVERTTIMESTAMP function converts a Julian timestamp to a value with data type TIMESTAMP.</p> @@ -30723,7 +30895,7 @@ LARGEINT value.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_converttimestamp">7.26.1. Considerations for CONVERTTIMESTAMP</h4> +<h4 id="considerations_for_converttimestamp">7.28.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> @@ -30749,7 +30921,7 @@ database and display these column values in a TIMESTAMP format.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_converttimestamp">7.26.2. Examples of CONVERTTIMESTAMP</h4> +<h4 id="examples_of_converttimestamp">7.28.2. Examples of CONVERTTIMESTAMP</h4> <div class="ulist"> <ul> <li> @@ -30782,7 +30954,7 @@ is the same value, 2008-04-03 21:05:36.143000.</p> </div> </div> <div class="sect2"> -<h3 id="cos_function">7.27. COS Function</h3> +<h3 id="cos_function">7.29. 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> @@ -30810,7 +30982,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.27.1. Examples of COS</h4> +<h4 id="examples_of_cos">7.29.1. Examples of COS</h4> <div class="ulist"> <ul> <li> @@ -30827,7 +30999,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.27.2. COSH Function</h4> +<h4 id="cosh_function">7.29.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> @@ -30854,7 +31026,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_cosh">7.27.3. Examples of COSH</h4> +<h4 id="examples_of_cosh">7.29.3. Examples of COSH</h4> <div class="ulist"> <ul> <li> @@ -30871,7 +31043,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.27.4. COUNT Function</h4> +<h4 id="count_function">7.29.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. @@ -30917,7 +31089,7 @@ values from the one-column table derived from the evaluation of </div> </div> <div class="sect3"> -<h4 id="considerations_for_count">7.27.5. Considerations for COUNT</h4> +<h4 id="considerations_for_count">7.29.5. Considerations for COUNT</h4> <div class="sect4"> <h5 id="operands-of-the-expression-1">Operands of the Expression</h5> <div class="paragraph"> @@ -30949,7 +31121,7 @@ COUNT(\*) returns the number of rows in the table.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_count">7.27.6. Examples of COUNT</h4> +<h4 id="examples_of_count">7.29.6. Examples of COUNT</h4> <div class="ulist"> <ul> <li> @@ -31042,7 +31214,7 @@ See <a href="#expressions">Expressions</a>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_crc32">7.27.7. examples of CR32</h4> +<h4 id="examples_of_crc32">7.29.7. examples of CR32</h4> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">>>SELECT CRC32('Trafodion') from dual; @@ -31064,7 +31236,7 @@ See <a href="#expressions">Expressions</a>.</p> </div> </div> <div class="sect2"> -<h3 id="current_function">7.28. CURRENT Function</h3> +<h3 id="current_function">7.30. 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> @@ -31100,7 +31272,7 @@ not a string value.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_current">7.28.1. Examples of CURRENT</h4> +<h4 id="examples_of_current">7.30.1. Examples of CURRENT</h4> <div class="ulist"> <ul> <li> @@ -31119,7 +31291,7 @@ SET ship_timestamp = CURRENT WHERE projcode = 1000;</code></pre> </div> </div> <div class="sect2"> -<h3 id="current_date_function">7.29. CURRENT_DATE Function</h3> +<h3 id="current_date_function">7.31. CURRENT_DATE Function</h3> <div class="paragraph"> <p>The CURRENT_DATE function returns the local current date as a value of type DATE.</p> @@ -31138,7 +31310,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.29.1. Examples of CURRENT_DATE</h4>
<TRUNCATED>
