http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/113b6ccc/docs/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html index 72d05db..6c659f5 100644 --- a/docs/sql_reference/index.html +++ b/docs/sql_reference/index.html @@ -1226,780 +1226,783 @@ table.CodeRay td.code>pre{padding:0} </li> <li><a href="#sql_functions_and_expressions">7. SQL Functions and Expressions</a> <ul class="sectlevel2"> -<li><a href="#standard_normalization">7.1. Standard Normalization</a></li> -<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="#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> +<li><a href="#categories">7.1. Categories</a> <ul class="sectlevel3"> -<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> +<li><a href="#_aggregate_set_functions">7.1.1. Aggregate (Set) Functions</a></li> +<li><a href="#character_string_functions">7.1.2. Character String Functions</a></li> +<li><a href="#datetime_functions">7.1.3. Datetime Functions</a></li> +<li><a href="#lob_functions">7.1.4. LOB Functions</a></li> +<li><a href="#mathematical_functions">7.1.5. Mathematical Functions</a></li> +<li><a href="#encryption_functions">7.1.6. Encryption Functions</a></li> +<li><a href="#sequence_functions">7.1.7. Sequence Functions</a></li> +<li><a href="#other_functions_and_expressions">7.1.8. Other Functions and Expressions</a></li> +<li><a href="#standard_normalization">7.1.9. Standard Normalization</a></li> +</ul> +</li> +<li><a href="#abs_function">7.2. ABS Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_abs">7.2.1. Examples of ABS</a></li> </ul> </li> -<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> +<li><a href="#acos_function">7.3. ACOS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_abs">7.10.1. Examples of ABS</a></li> +<li><a href="#examples_of_acos">7.3.1. Examples of ACOS</a></li> +<li><a href="#add_months_function">7.3.2. ADD_MONTHS Function</a></li> +<li><a href="#examples_of_add_months">7.3.3. Examples of ADD_MONTHS</a></li> </ul> </li> -<li><a href="#acos_function">7.11. ACOS Function</a> +<li><a href="#ascii_function">7.4. ASCII Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#considerations_for_ascii">7.4.1. Considerations For ASCII</a></li> +<li><a href="#examples_of_ascii">7.4.2. Examples of ASCII</a></li> </ul> </li> -<li><a href="#ascii_function">7.12. ASCII Function</a> +<li><a href="#asin_function">7.5. 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.5.1. Considerations for ASCII</a></li> +<li><a href="#examples_of_ascii">7.5.2. Examples of ASCII</a></li> </ul> </li> -<li><a href="#asin_function">7.13. ASIN Function</a> +<li><a href="#asin_function">7.6. ASIN Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#examples_of_asin">7.6.1. Examples of ASIN</a></li> </ul> </li> -<li><a href="#asin_function">7.14. ASIN Function</a> +<li><a href="#atan_function">7.7. ATAN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_asin">7.14.1. Examples of ASIN</a></li> +<li><a href="#examples_of_atan">7.7.1. Examples of ATAN</a></li> </ul> </li> -<li><a href="#atan_function">7.15. ATAN Function</a> +<li><a href="#atan2_function">7.8. ATAN2 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_atan">7.15.1. Examples of ATAN</a></li> +<li><a href="#examples_of_atan2">7.8.1. Examples of ATAN2</a></li> </ul> </li> -<li><a href="#atan2_function">7.16. ATAN2 Function</a> +<li><a href="#authname_function">7.9. AUTHNAME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_atan2">7.16.1. Examples of ATAN2</a></li> +<li><a href="#considerations_for_authname">7.9.1. Considerations for AUTHNAME</a></li> +<li><a href="#examples_of_authname">7.9.2. Examples of AUTHNAME</a></li> </ul> </li> -<li><a href="#authname_function">7.17. AUTHNAME Function</a> +<li><a href="#avg_function">7.10. AVG 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> +<li><a href="#considerations_for_avg">7.10.1. Considerations for AVG</a></li> </ul> </li> -<li><a href="#avg_function">7.18. AVG Function</a> +<li><a href="#bitand_function">7.11. BITAND Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_avg">7.18.1. Considerations for AVG</a></li> +<li><a href="#considerations_for_bitand">7.11.1. Considerations for BITAND</a></li> +<li><a href="#examples_of_bitand">7.11.2. Examples of BITAND</a></li> </ul> </li> -<li><a href="#bitand_function">7.19. BITAND Function</a> +<li><a href="#buffertolob_function">7.12. BUFFERTOLOB 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> +<li><a href="#buffertolob_function_syntax">7.12.1. Syntax Descriptions of BUFFERTOLOB Function</a></li> +<li><a href="#buffertolob_function_examples">7.12.2. Examples of BUFFERTOLOB Function</a></li> </ul> </li> -<li><a href="#buffertolob_function">7.20. BUFFERTOLOB Function</a> +<li><a href="#case_expression">7.13. CASE (Conditional) Expression</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> +<li><a href="#considerations_for_case">7.13.1. Considerations for CASE</a></li> +<li><a href="#examples_of_case">7.13.2. Examples of CASE</a></li> </ul> </li> -<li><a href="#case_expression">7.21. CASE (Conditional) Expression</a> +<li><a href="#cast_expression">7.14. CAST Expression</a> <ul class="sectlevel3"> -<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> +<li><a href="#considerations_for_cast">7.14.1. Considerations for CAST</a></li> +<li><a href="#examples_of_cast">7.14.2. Examples of CAST</a></li> </ul> </li> -<li><a href="#cast_expression">7.22. CAST Expression</a> +<li><a href="#ceiling_function">7.15. CEILING Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#examples_of_ceiling">7.15.1. Examples of CEILING</a></li> +<li><a href="#char_function">7.15.2. CHAR Function</a></li> +<li><a href="#considerations_for_char">7.15.3. Considerations for CHAR</a></li> +<li><a href="#examples_of_char">7.15.4. Examples of CHAR</a></li> </ul> </li> -<li><a href="#ceiling_function">7.23. CEILING Function</a> +<li><a href="#char_length_function">7.16. CHAR_LENGTH Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#considerations_for_char_length">7.16.1. Considerations for CHAR_LENGTH</a></li> +<li><a href="#examples_of_char_length">7.16.2. Examples of CHAR_LENGTH</a></li> </ul> </li> -<li><a href="#char_length_function">7.24. CHAR_LENGTH Function</a> +<li><a href="#coalesce_function">7.17. COALESCE Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#examples_of_coalesce">7.17.1. Examples of COALESCE</a></li> </ul> </li> -<li><a href="#coalesce_function">7.25. COALESCE Function</a> +<li><a href="#code_value_function">7.18. CODE_VALUE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_coalesce">7.25.1. Examples of COALESCE</a></li> +<li><a href="#examples_of_code_value_function">7.18.1. Examples of CODE_VALUE Function</a></li> </ul> </li> -<li><a href="#code_value_function">7.26. CODE_VALUE Function</a> +<li><a href="#concat_function">7.19. CONCAT 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="#concatenation_operator">7.19.1. Concatenation Operator (||)</a></li> +<li><a href="#considerations_for_concat">7.19.2. Considerations for CONCAT</a></li> +<li><a href="#examples_of_concat">7.19.3. Examples of CONCAT</a></li> </ul> </li> -<li><a href="#concat_function">7.27. CONCAT Function</a> +<li><a href="#converttohex_function">7.20. CONVERTTOHEX Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#considerations_for_converttohex">7.20.1. Considerations for CONVERTTOHEX</a></li> +<li><a href="#examples_of_converttohex">7.20.2. Examples of CONVERTTOHEX</a></li> </ul> </li> -<li><a href="#converttohex_function">7.28. CONVERTTOHEX Function</a> +<li><a href="#converttimestamp_function">7.21. CONVERTTIMESTAMP Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#considerations_for_converttimestamp">7.21.1. Considerations for CONVERTTIMESTAMP</a></li> +<li><a href="#examples_of_converttimestamp">7.21.2. Examples of CONVERTTIMESTAMP</a></li> </ul> </li> -<li><a href="#converttimestamp_function">7.29. CONVERTTIMESTAMP Function</a> +<li><a href="#cos_function">7.22. COS Function</a> <ul class="sectlevel3"> -<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> +<li><a href="#examples_of_cos">7.22.1. Examples of COS</a></li> +<li><a href="#cosh_function">7.22.2. COSH Function</a></li> +<li><a href="#examples_of_cosh">7.22.3. Examples of COSH</a></li> </ul> </li> -<li><a href="#cos_function">7.30. COS Function</a> +<li><a href="#count_function">7.23. COUNT Function</a> <ul class="sectlevel3"> -<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="#considerations_for_count">7.23.1. Considerations for COUNT</a></li> +<li><a href="#examples_of_count">7.23.2. Examples of COUNT</a></li> +<li><a href="#examples_of_crc32">7.23.3. examples of CR32</a></li> </ul> </li> -<li><a href="#count_function">7.31. COUNT Function</a> +<li><a href="#current_function">7.24. CURRENT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_count">7.31.1. Considerations for COUNT</a></li> -<li><a href="#examples_of_count">7.31.2. Examples of COUNT</a></li> -<li><a href="#examples_of_crc32">7.31.3. examples of CR32</a></li> +<li><a href="#examples_of_current">7.24.1. Examples of CURRENT</a></li> </ul> </li> -<li><a href="#current_function">7.32. CURRENT Function</a> +<li><a href="#current_date_function">7.25. CURRENT_DATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current">7.32.1. Examples of CURRENT</a></li> +<li><a href="#examples_of_current_date">7.25.1. Examples of CURRENT_DATE</a></li> </ul> </li> -<li><a href="#current_date_function">7.33. CURRENT_DATE Function</a> +<li><a href="#current_time_function">7.26. CURRENT_TIME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current_date">7.33.1. Examples of CURRENT_DATE</a></li> +<li><a href="#examples_of_current_time">7.26.1. Examples of CURRENT_TIME</a></li> </ul> </li> -<li><a href="#current_time_function">7.34. CURRENT_TIME Function</a> +<li><a href="#current_timestamp_function">7.27. CURRENT_TIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current_time">7.34.1. Examples of CURRENT_TIME</a></li> +<li><a href="#examples_of_current_timestamp">7.27.1. Examples of CURRENT_TIMESTAMP</a></li> </ul> </li> -<li><a href="#current_timestamp_function">7.35. CURRENT_TIMESTAMP Function</a> +<li><a href="#current_user_function">7.28. CURRENT_USER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_current_timestamp">7.35.1. Examples of CURRENT_TIMESTAMP</a></li> +<li><a href="#considerations_for_current_user">7.28.1. Considerations for CURRENT_USER</a></li> +<li><a href="#examples_of_current_user">7.28.2. Examples of CURRENT_USER</a></li> </ul> </li> -<li><a href="#current_user_function">7.36. CURRENT_USER Function</a> +<li><a href="#date_add_function">7.29. DATE_ADD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_current_user">7.36.1. Considerations for CURRENT_USER</a></li> -<li><a href="#examples_of_current_user">7.36.2. Examples of CURRENT_USER</a></li> +<li><a href="#examples_of_date_add">7.29.1. Examples of DATE_ADD</a></li> </ul> </li> -<li><a href="#date_add_function">7.37. DATE_ADD Function</a> +<li><a href="#date_sub_function">7.30. DATE_SUB Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_add">7.37.1. Examples of DATE_ADD</a></li> +<li><a href="#examples_of_date_sub">7.30.1. Examples of DATE_SUB</a></li> </ul> </li> -<li><a href="#date_sub_function">7.38. DATE_SUB Function</a> +<li><a href="#dateadd_function">7.31. DATEADD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_sub">7.38.1. Examples of DATE_SUB</a></li> +<li><a href="#examples_of_dateadd">7.31.1. Examples of DATEADD</a></li> </ul> </li> -<li><a href="#dateadd_function">7.39. DATEADD Function</a> +<li><a href="#datediff_function">7.32. DATEDIFF Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dateadd">7.39.1. Examples of DATEADD</a></li> +<li><a href="#syntax_description_of_datediff">7.32.1. Syntax Description of DATEDIFF</a></li> +<li><a href="#considerations_for_datediff">7.32.2. Considerations for DATEDIFF</a></li> +<li><a href="#examples_of_datediff">7.32.3. Examples of DATEDIFF</a></li> </ul> </li> -<li><a href="#datediff_function">7.40. DATEDIFF Function</a> +<li><a href="#dateformat_function">7.33. DATEFORMAT Function</a> <ul class="sectlevel3"> -<li><a href="#syntax_description_of_datediff">7.40.1. Syntax Description of DATEDIFF</a></li> -<li><a href="#considerations_for_datediff">7.40.2. Considerations for DATEDIFF</a></li> -<li><a href="#examples_of_datediff">7.40.3. Examples of DATEDIFF</a></li> +<li><a href="#considerations_for_dateformat">7.33.1. Considerations for DATEFORMAT</a></li> +<li><a href="#examples_of_dateformat">7.33.2. Examples of DATEFORMAT</a></li> </ul> </li> -<li><a href="#dateformat_function">7.41. DATEFORMAT Function</a> +<li><a href="#date_part_function_of_an_interval">7.34. DATE_PART Function (of an Interval)</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_dateformat">7.41.1. Considerations for DATEFORMAT</a></li> -<li><a href="#examples_of_dateformat">7.41.2. Examples of DATEFORMAT</a></li> +<li><a href="#examples_of_date_part">7.34.1. Examples of DATE_PART</a></li> </ul> </li> -<li><a href="#date_part_function_of_an_interval">7.42. DATE_PART Function (of an Interval)</a> +<li><a href="#date_part_function_of_a_timestamp">7.35. DATE_PART Function (of a Timestamp)</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_part">7.42.1. Examples of DATE_PART</a></li> +<li><a href="#examples_of_date_part">7.35.1. Examples of DATE_PART</a></li> </ul> </li> -<li><a href="#date_part_function_of_a_timestamp">7.43. DATE_PART Function (of a Timestamp)</a> +<li><a href="#date_trunc_function">7.36. DATE_TRUNC Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_part">7.43.1. Examples of DATE_PART</a></li> +<li><a href="#examples_of_date_trunc">7.36.1. Examples of DATE_TRUNC</a></li> </ul> </li> -<li><a href="#date_trunc_function">7.44. DATE_TRUNC Function</a> +<li><a href="#day_function">7.37. DAY Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_date_trunc">7.44.1. Examples of DATE_TRUNC</a></li> +<li><a href="#examples_of_day">7.37.1. Examples of Day</a></li> </ul> </li> -<li><a href="#day_function">7.45. DAY Function</a> +<li><a href="#dayname_function">7.38. DAYNAME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_day">7.45.1. Examples of Day</a></li> +<li><a href="#considerations_for_dayname">7.38.1. Considerations for DAYNAME</a></li> +<li><a href="#examples_of_dayname">7.38.2. Examples of DAYNAME</a></li> </ul> </li> -<li><a href="#dayname_function">7.46. DAYNAME Function</a> +<li><a href="#dayofmonth_function">7.39. DAYOFMONTH Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_dayname">7.46.1. Considerations for DAYNAME</a></li> -<li><a href="#examples_of_dayname">7.46.2. Examples of DAYNAME</a></li> +<li><a href="#examples_of_dayofmonth">7.39.1. Examples of DAYOFMONTH</a></li> </ul> </li> -<li><a href="#dayofmonth_function">7.47. DAYOFMONTH Function</a> +<li><a href="#dayofweek_function">7.40. DAYOFWEEK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dayofmonth">7.47.1. Examples of DAYOFMONTH</a></li> +<li><a href="#examples_of_dayofweek">7.40.1. Examples of DAYOFWEEK</a></li> </ul> </li> -<li><a href="#dayofweek_function">7.48. DAYOFWEEK Function</a> +<li><a href="#dayofyear_function">7.41. DAYOFYEAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dayofweek">7.48.1. Examples of DAYOFWEEK</a></li> +<li><a href="#examples_of_dayofyear">7.41.1. Examples of DAYOFYEAR</a></li> </ul> </li> -<li><a href="#dayofyear_function">7.49. DAYOFYEAR Function</a> +<li><a href="#Decode_function">7.42. DECODE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_dayofyear">7.49.1. Examples of DAYOFYEAR</a></li> +<li><a href="#considerations_for_decode">7.42.1. Considerations for DECODE</a></li> +<li><a href="#_examples_of_decode">7.42.2. Examples of DECODE</a></li> </ul> </li> -<li><a href="#Decode_function">7.50. DECODE Function</a> +<li><a href="#degrees_function">7.43. DEGREES Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_decode">7.50.1. Considerations for DECODE</a></li> -<li><a href="#_examples_of_decode">7.50.2. Examples of DECODE</a></li> +<li><a href="#examples_of_degrees">7.43.1. Examples of Degrees</a></li> </ul> </li> -<li><a href="#degrees_function">7.51. DEGREES Function</a> +<li><a href="#diff1_function">7.44. DIFF1 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_degrees">7.51.1. Examples of Degrees</a></li> +<li><a href="#considerations_for_diff1">7.44.1. Considerations for DIFF1</a></li> +<li><a href="#examples_of_diff1">7.44.2. Examples of DIFF1</a></li> </ul> </li> -<li><a href="#diff1_function">7.52. DIFF1 Function</a> +<li><a href="#diff2_function">7.45. DIFF2 Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_diff1">7.52.1. Considerations for DIFF1</a></li> -<li><a href="#examples_of_diff1">7.52.2. Examples of DIFF1</a></li> +<li><a href="#considerations_for_diff2">7.45.1. Considerations for DIFF2</a></li> +<li><a href="#examples_of_diff2">7.45.2. Examples of DIFF2</a></li> </ul> </li> -<li><a href="#diff2_function">7.53. DIFF2 Function</a> +<li><a href="#emptyblob_function">7.46. EMPTY_BLOB() Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_diff2">7.53.1. Considerations for DIFF2</a></li> -<li><a href="#examples_of_diff2">7.53.2. Examples of DIFF2</a></li> +<li><a href="#syntax_descriptions_of_emptyblob_function">7.46.1. Syntax Descriptions of EMPTY_BLOB() Function</a></li> +<li><a href="#considerations_for_emptyblob_function">7.46.2. Considerations for EMPTY_BLOB() Function</a></li> +<li><a href="#examples_of_emptyblob_function">7.46.3. Examples of EMPTY_BLOB() Function</a></li> </ul> </li> -<li><a href="#emptyblob_function">7.54. EMPTY_BLOB() Function</a> +<li><a href="#emptyclob_function">7.47. EMPTY_CLOB() Function</a> <ul class="sectlevel3"> -<li><a href="#syntax_descriptions_of_emptyblob_function">7.54.1. Syntax Descriptions of EMPTY_BLOB() Function</a></li> -<li><a href="#considerations_for_emptyblob_function">7.54.2. Considerations for EMPTY_BLOB() Function</a></li> -<li><a href="#examples_of_emptyblob_function">7.54.3. Examples of EMPTY_BLOB() Function</a></li> +<li><a href="#syntax_descriptions_of_emptyclob_function">7.47.1. Syntax Descriptions of EMPTY_CLOB() Function</a></li> +<li><a href="#considerations_for_emptyclob_function">7.47.2. Considerations for EMPTY_CLOB() Function</a></li> +<li><a href="#examples_of_emptyclob_function">7.47.3. Examples of EMPTY_CLOB() Function</a></li> </ul> </li> -<li><a href="#emptyclob_function">7.55. EMPTY_CLOB() Function</a> +<li><a href="#exp_function">7.48. EXP Function</a> <ul class="sectlevel3"> -<li><a href="#syntax_descriptions_of_emptyclob_function">7.55.1. Syntax Descriptions of EMPTY_CLOB() Function</a></li> -<li><a href="#considerations_for_emptyclob_function">7.55.2. Considerations for EMPTY_CLOB() Function</a></li> -<li><a href="#examples_of_emptyclob_function">7.55.3. Examples of EMPTY_CLOB() Function</a></li> +<li><a href="#examples_of_exp">7.48.1. Examples of EXP</a></li> </ul> </li> -<li><a href="#exp_function">7.56. EXP Function</a> +<li><a href="#explain_function">7.49. EXPLAIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_exp">7.56.1. Examples of EXP</a></li> +<li><a href="#considerations_for_explain_function">7.49.1. Considerations for EXPLAIN Function</a></li> +<li><a href="#examples_of_explain_function">7.49.2. Examples of EXPLAIN Function</a></li> </ul> </li> -<li><a href="#explain_function">7.57. EXPLAIN Function</a> +<li><a href="#externaltolob_function">7.50. EXTERNALTOLOB Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_explain_function">7.57.1. Considerations for EXPLAIN Function</a></li> -<li><a href="#examples_of_explain_function">7.57.2. Examples of EXPLAIN Function</a></li> +<li><a href="#externaltolob_function_syntax">7.50.1. Syntax Descriptions of EXTERNALTOLOB Function</a></li> +<li><a href="#externaltolob_function_considerations">7.50.2. Considerations for EXTERNALTOLOB Function</a></li> +<li><a href="#externaltolob_function_examples">7.50.3. Examples of EXTERNALTOLOB Function</a></li> </ul> </li> -<li><a href="#externaltolob_function">7.58. EXTERNALTOLOB Function</a> +<li><a href="#extract_function">7.51. EXTRACT Function</a> <ul class="sectlevel3"> -<li><a href="#externaltolob_function_syntax">7.58.1. Syntax Descriptions of EXTERNALTOLOB Function</a></li> -<li><a href="#externaltolob_function_considerations">7.58.2. Considerations for EXTERNALTOLOB Function</a></li> -<li><a href="#externaltolob_function_examples">7.58.3. Examples of EXTERNALTOLOB Function</a></li> +<li><a href="#extract_function_syntax">7.51.1. Syntax Descriptions of Extract Function</a></li> +<li><a href="#examples_of_extract">7.51.2. Examples of EXTRACT</a></li> </ul> </li> -<li><a href="#extract_function">7.59. EXTRACT Function</a> +<li><a href="#filetolob_function">7.52. FILETOLOB Function</a> <ul class="sectlevel3"> -<li><a href="#extract_function_syntax">7.59.1. Syntax Descriptions of Extract Function</a></li> -<li><a href="#examples_of_extract">7.59.2. Examples of EXTRACT</a></li> +<li><a href="#filetolob_function_syntax">7.52.1. Syntax Descriptions of FILETOLOB Function</a></li> +<li><a href="#filetolob_function_examples">7.52.2. Examples of FILETOLOB Function</a></li> </ul> </li> -<li><a href="#filetolob_function">7.60. FILETOLOB Function</a> +<li><a href="#group_concat_function">7.53. GROUP_CONCAT Function</a> <ul class="sectlevel3"> -<li><a href="#filetolob_function_syntax">7.60.1. Syntax Descriptions of FILETOLOB Function</a></li> -<li><a href="#filetolob_function_examples">7.60.2. Examples of FILETOLOB Function</a></li> +<li><a href="#examples_of_group_concat">7.53.1. Examples of GROUP_CONCAT</a></li> </ul> </li> -<li><a href="#group_concat_function">7.61. GROUP_CONCAT Function</a> +<li><a href="#hour_function">7.54. HOUR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_group_concat">7.61.1. Examples of GROUP_CONCAT</a></li> +<li><a href="#examples_of_hour">7.54.1. Examples of HOUR</a></li> </ul> </li> -<li><a href="#hour_function">7.62. HOUR Function</a> +<li><a href="#insert_function">7.55. INSERT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_hour">7.62.1. Examples of HOUR</a></li> +<li><a href="#examples_of_insert">7.55.1. Examples of INSERT</a></li> </ul> </li> -<li><a href="#insert_function">7.63. INSERT Function</a> +<li><a href="#is_ipv4_function">7.56. IS_IPV4 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_insert">7.63.1. Examples of INSERT</a></li> +<li><a href="#examples_of_is_ipv4">7.56.1. Examples of IS_IPV4</a></li> </ul> </li> -<li><a href="#is_ipv4_function">7.64. IS_IPV4 Function</a> +<li><a href="#is_ipv6_function">7.57. IS_IPV6 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_is_ipv4">7.64.1. Examples of IS_IPV4</a></li> +<li><a href="#examples_of_is_ipv6">7.57.1. Examples of IS_IPV6</a></li> </ul> </li> -<li><a href="#is_ipv6_function">7.65. IS_IPV6 Function</a> +<li><a href="#inet_aton_function">7.58. INET_ATON Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_is_ipv6">7.65.1. Examples of IS_IPV6</a></li> +<li><a href="#examples_of_inet_aton">7.58.1. Examples of INET_ATON</a></li> </ul> </li> -<li><a href="#inet_aton_function">7.66. INET_ATON Function</a> +<li><a href="#inet_ntoa_function">7.59. INET_NTOA Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_inet_aton">7.66.1. Examples of INET_ATON</a></li> +<li><a href="#examples_of_inet_ntoa">7.59.1. Examples of INET_NTOA</a></li> </ul> </li> -<li><a href="#inet_ntoa_function">7.67. INET_NTOA Function</a> +<li><a href="#isnull_function">7.60. ISNULL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_inet_ntoa">7.67.1. Examples of INET_NTOA</a></li> +<li><a href="#examples_of_isnull">7.60.1. Examples of ISNULL</a></li> </ul> </li> -<li><a href="#isnull_function">7.68. ISNULL Function</a> +<li><a href="#juliantimestamp_function">7.61. JULIANTIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_isnull">7.68.1. Examples of ISNULL</a></li> +<li><a href="#considerations_for_juliantimestamp">7.61.1. Considerations for JULIANTIMESTAMP</a></li> +<li><a href="#examples_of_juliantimestamp">7.61.2. Examples of JULIANTIMESTAMP</a></li> </ul> </li> -<li><a href="#juliantimestamp_function">7.69. JULIANTIMESTAMP Function</a> +<li><a href="#lastnotnull_function">7.62. LASTNOTNULL Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_juliantimestamp">7.69.1. Considerations for JULIANTIMESTAMP</a></li> -<li><a href="#examples_of_juliantimestamp">7.69.2. Examples of JULIANTIMESTAMP</a></li> +<li><a href="#examples_of_lastnotnull">7.62.1. Examples of LASTNOTNULL</a></li> </ul> </li> -<li><a href="#lastnotnull_function">7.70. LASTNOTNULL Function</a> +<li><a href="#lcase_function">7.63. LCASE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lastnotnull">7.70.1. Examples of LASTNOTNULL</a></li> +<li><a href="#examples_of_lcase">7.63.1. Examples of LCASE</a></li> +<li><a href="#left_function">7.63.2. LEFT Function</a></li> +<li><a href="#examples_of_left">7.63.3. Examples of LEFT</a></li> </ul> </li> -<li><a href="#lcase_function">7.71. LCASE Function</a> +<li><a href="#locate_function">7.64. LOCATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lcase">7.71.1. Examples of LCASE</a></li> -<li><a href="#left_function">7.71.2. LEFT Function</a></li> -<li><a href="#examples_of_left">7.71.3. Examples of LEFT</a></li> +<li><a href="#considerations_for_locate">7.64.1. Considerations for LOCATE</a></li> +<li><a href="#examples_of_locate">7.64.2. Examples of LOCATE</a></li> </ul> </li> -<li><a href="#locate_function">7.72. LOCATE Function</a> +<li><a href="#log_function">7.65. LOG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_locate">7.72.1. Considerations for LOCATE</a></li> -<li><a href="#examples_of_locate">7.72.2. Examples of LOCATE</a></li> +<li><a href="#examples_of_log">7.65.1. Examples of LOG</a></li> +<li><a href="#log10_function">7.65.2. LOG10 Function</a></li> +<li><a href="#examples_of_log10">7.65.3. Examples of LOG10</a></li> </ul> </li> -<li><a href="#log_function">7.73. LOG Function</a> +<li><a href="#lower_function">7.66. LOWER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_log">7.73.1. Examples of LOG</a></li> -<li><a href="#log10_function">7.73.2. LOG10 Function</a></li> -<li><a href="#examples_of_log10">7.73.3. Examples of LOG10</a></li> +<li><a href="#considerations_for_lower">7.66.1. Considerations for LOWER</a></li> +<li><a href="#examples_of_lower">7.66.2. Examples of LOWER</a></li> </ul> </li> -<li><a href="#lower_function">7.74. LOWER Function</a> +<li><a href="#lpad_function">7.67. LPAD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_lower">7.74.1. Considerations for LOWER</a></li> -<li><a href="#examples_of_lower">7.74.2. Examples of LOWER</a></li> +<li><a href="#examples_of_lpad">7.67.1. Examples of LPAD</a></li> </ul> </li> -<li><a href="#lpad_function">7.75. LPAD Function</a> +<li><a href="#ltrim_function">7.68. LTRIM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lpad">7.75.1. Examples of LPAD</a></li> +<li><a href="#considerations_for_ltrim">7.68.1. Considerations for LTRIM</a></li> +<li><a href="#examples_of_ltrim">7.68.2. Examples of LTRIM</a></li> </ul> </li> -<li><a href="#ltrim_function">7.76. LTRIM Function</a> +<li><a href="#max_function">7.69. MAX/MAXIMUM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ltrim">7.76.1. Considerations for LTRIM</a></li> -<li><a href="#examples_of_ltrim">7.76.2. Examples of LTRIM</a></li> +<li><a href="#considerations_for_max">7.69.1. Considerations for MAX/MAXIMUM</a></li> +<li><a href="#operands_of_the_expression">7.69.2. Operands of the Expression</a></li> +<li><a href="#examples_of_max">7.69.3. Examples of MAX/MAXIMUM</a></li> </ul> </li> -<li><a href="#max_function">7.77. MAX/MAXIMUM Function</a> +<li><a href="#md5_function">7.70. MD5 Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_max">7.77.1. Considerations for MAX/MAXIMUM</a></li> -<li><a href="#operands_of_the_expression">7.77.2. Operands of the Expression</a></li> -<li><a href="#examples_of_max">7.77.3. Examples of MAX/MAXIMUM</a></li> +<li><a href="#examples_of_md5">7.70.1. Examples of MD5</a></li> </ul> </li> -<li><a href="#md5_function">7.78. MD5 Function</a> +<li><a href="#min_function">7.71. MIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_md5">7.78.1. Examples of MD5</a></li> +<li><a href="#considerations_for_min">7.71.1. Considerations for MIN</a></li> +<li><a href="#examples_of_min">7.71.2. Examples of MIN</a></li> </ul> </li> -<li><a href="#min_function">7.79. MIN Function</a> +<li><a href="#minute_function">7.72. MINUTE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_min">7.79.1. Considerations for MIN</a></li> -<li><a href="#examples_of_min">7.79.2. Examples of MIN</a></li> +<li><a href="#examples_of_minute">7.72.1. Examples of minute</a></li> </ul> </li> -<li><a href="#minute_function">7.80. MINUTE Function</a> +<li><a href="#mod_function">7.73. MOD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_minute">7.80.1. Examples of minute</a></li> +<li><a href="#examples_of_mod">7.73.1. Examples of MOD</a></li> </ul> </li> -<li><a href="#mod_function">7.81. MOD Function</a> +<li><a href="#month_function">7.74. MONTH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_mod">7.81.1. Examples of MOD</a></li> +<li><a href="#examples_of_month">7.74.1. Examples of MONTH</a></li> </ul> </li> -<li><a href="#month_function">7.82. MONTH Function</a> +<li><a href="#monthname_function">7.75. MONTHNAME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_month">7.82.1. Examples of MONTH</a></li> +<li><a href="#considerations_for_monthname">7.75.1. Considerations for MONTHNAME</a></li> +<li><a href="#examples_of_monthname">7.75.2. Examples of MONTHNAME</a></li> </ul> </li> -<li><a href="#monthname_function">7.83. MONTHNAME Function</a> +<li><a href="#movingavg_function">7.76. MOVINGAVG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_monthname">7.83.1. Considerations for MONTHNAME</a></li> -<li><a href="#examples_of_monthname">7.83.2. Examples of MONTHNAME</a></li> +<li><a href="#examples_of_movingavg">7.76.1. Examples of MOVINGAVG</a></li> </ul> </li> -<li><a href="#movingavg_function">7.84. MOVINGAVG Function</a> +<li><a href="#movingcount_function">7.77. MOVINGCOUNT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingavg">7.84.1. Examples of MOVINGAVG</a></li> +<li><a href="#considerations_for_movingcount">7.77.1. Considerations for MOVINGCOUNT</a></li> +<li><a href="#examples_of_movingcount">7.77.2. Examples of MOVINGCOUNT</a></li> </ul> </li> -<li><a href="#movingcount_function">7.85. MOVINGCOUNT Function</a> +<li><a href="#movingmax_function">7.78. MOVINGMAX Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_movingcount">7.85.1. Considerations for MOVINGCOUNT</a></li> -<li><a href="#examples_of_movingcount">7.85.2. Examples of MOVINGCOUNT</a></li> +<li><a href="#examples_of_movingmax">7.78.1. Examples of MOVINGMAX</a></li> </ul> </li> -<li><a href="#movingmax_function">7.86. MOVINGMAX Function</a> +<li><a href="#movingmin_function">7.79. MOVINGMIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingmax">7.86.1. Examples of MOVINGMAX</a></li> +<li><a href="#examples_of_movingmin">7.79.1. Examples of MOVINGMIN</a></li> </ul> </li> -<li><a href="#movingmin_function">7.87. MOVINGMIN Function</a> +<li><a href="#movingstddev_function">7.80. MOVINGSTDDEV Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingmin">7.87.1. Examples of MOVINGMIN</a></li> +<li><a href="#examples_of_movingstddev">7.80.1. Examples of MOVINGSTDDEV</a></li> </ul> </li> -<li><a href="#movingstddev_function">7.88. MOVINGSTDDEV Function</a> +<li><a href="#movingsum_function">7.81. MOVINGSUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingstddev">7.88.1. Examples of MOVINGSTDDEV</a></li> +<li><a href="#examples_of_movingsum">7.81.1. Examples of MOVINGSUM</a></li> </ul> </li> -<li><a href="#movingsum_function">7.89. MOVINGSUM Function</a> +<li><a href="#movingvariance_function">7.82. MOVINGVARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingsum">7.89.1. Examples of MOVINGSUM</a></li> +<li><a href="#examples_of_movingvariance">7.82.1. Examples of MOVINGVARIANCE</a></li> +<li><a href="#nullif_function">7.82.2. NULLIF Function</a></li> +<li><a href="#examples_of_nullif">7.82.3. Examples of NULLIF</a></li> </ul> </li> -<li><a href="#movingvariance_function">7.90. MOVINGVARIANCE Function</a> +<li><a href="#nullifzero_function">7.83. NULLIFZERO Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingvariance">7.90.1. Examples of MOVINGVARIANCE</a></li> -<li><a href="#nullif_function">7.90.2. NULLIF Function</a></li> -<li><a href="#examples_of_nullif">7.90.3. Examples of NULLIF</a></li> +<li><a href="#examples_of_nullifzero">7.83.1. Examples of NULLIFZERO</a></li> </ul> </li> -<li><a href="#nullifzero_function">7.91. NULLIFZERO Function</a> +<li><a href="#nvl_function">7.84. NVL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_nullifzero">7.91.1. Examples of NULLIFZERO</a></li> +<li><a href="#examples_of_nvl">7.84.1. Examples of NVL</a></li> </ul> </li> -<li><a href="#nvl_function">7.92. NVL Function</a> +<li><a href="#octet_length_function">7.85. OCTET_LENGTH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_nvl">7.92.1. Examples of NVL</a></li> +<li><a href="#considerations_for_octet_length">7.85.1. Considerations for OCTET_LENGTH</a></li> +<li><a href="#offset_function">7.85.2. OFFSET Function</a></li> +<li><a href="#examples_of_offset">7.85.3. Examples of OFFSET</a></li> </ul> </li> -<li><a href="#octet_length_function">7.93. OCTET_LENGTH Function</a> +<li><a href="#pi_function">7.86. PI Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_octet_length">7.93.1. Considerations for OCTET_LENGTH</a></li> -<li><a href="#offset_function">7.93.2. OFFSET Function</a></li> -<li><a href="#examples_of_offset">7.93.3. Examples of OFFSET</a></li> +<li><a href="#examples_of_pi">7.86.1. Examples of PI</a></li> </ul> </li> -<li><a href="#pi_function">7.94. PI Function</a> +<li><a href="#position_function">7.87. POSITION Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_pi">7.94.1. Examples of PI</a></li> +<li><a href="#considerations_for_position">7.87.1. Considerations for POSITION</a></li> +<li><a href="#examples_of_position">7.87.2. Examples of POSITION</a></li> </ul> </li> -<li><a href="#position_function">7.95. POSITION Function</a> +<li><a href="#power_function">7.88. POWER Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_position">7.95.1. Considerations for POSITION</a></li> -<li><a href="#examples_of_position">7.95.2. Examples of POSITION</a></li> +<li><a href="#examples_of_power">7.88.1. Examples of POWER</a></li> </ul> </li> -<li><a href="#power_function">7.96. POWER Function</a> +<li><a href="#quarter_function">7.89. QUARTER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_power">7.96.1. Examples of POWER</a></li> +<li><a href="#examples_of_quarter">7.89.1. Examples of QUARTER</a></li> </ul> </li> -<li><a href="#quarter_function">7.97. QUARTER Function</a> +<li><a href="#radians_function">7.90. RADIANS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_quarter">7.97.1. Examples of QUARTER</a></li> +<li><a href="#examples_of_radians">7.90.1. Examples of RADIANS</a></li> </ul> </li> -<li><a href="#radians_function">7.98. RADIANS Function</a> +<li><a href="#runningrank_function">7.91. RANK/RUNNINGRANK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_radians">7.98.1. Examples of RADIANS</a></li> +<li><a href="#considerations_for_runningrank">7.91.1. Considerations for RANK/RUNNINGRANK</a></li> +<li><a href="#examples_of_runningrank">7.91.2. Examples of RANK/RUNNINGRANK</a></li> </ul> </li> -<li><a href="#runningrank_function">7.99. RANK/RUNNINGRANK Function</a> +<li><a href="#repeat_function">7.92. REPEAT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningrank">7.99.1. Considerations for RANK/RUNNINGRANK</a></li> -<li><a href="#examples_of_runningrank">7.99.2. Examples of RANK/RUNNINGRANK</a></li> +<li><a href="#examples_of_repeat">7.92.1. Examples of REPEAT</a></li> </ul> </li> -<li><a href="#repeat_function">7.100. REPEAT Function</a> +<li><a href="#replace_function">7.93. REPLACE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_repeat">7.100.1. Examples of REPEAT</a></li> +<li><a href="#examples_of_replace">7.93.1. Examples of REPLACE</a></li> </ul> </li> -<li><a href="#replace_function">7.101. REPLACE Function</a> +<li><a href="#right_function">7.94. RIGHT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_replace">7.101.1. Examples of REPLACE</a></li> +<li><a href="#examples_of_right">7.94.1. Examples of RIGHT</a></li> </ul> </li> -<li><a href="#right_function">7.102. RIGHT Function</a> +<li><a href="#rollup_function">7.95. ROLLUP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_right">7.102.1. Examples of RIGHT</a></li> +<li><a href="#considerations_for_rollup">7.95.1. Considerations for ROLLUP</a></li> +<li><a href="#examples_of_rollup">7.95.2. Examples of ROLLUP</a></li> </ul> </li> -<li><a href="#rollup_function">7.103. ROLLUP Function</a> +<li><a href="#round_function">7.96. ROUND Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rollup">7.103.1. Considerations for ROLLUP</a></li> -<li><a href="#examples_of_rollup">7.103.2. Examples of ROLLUP</a></li> +<li><a href="#examples_of_round">7.96.1. Examples of ROUND</a></li> </ul> </li> -<li><a href="#round_function">7.104. ROUND Function</a> +<li><a href="#rows_since_function">7.97. ROWS SINCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_round">7.104.1. Examples of ROUND</a></li> +<li><a href="#considerations_for_rows_since">7.97.1. Considerations for ROWS SINCE</a></li> +<li><a href="#examples_of_rows_since">7.97.2. Examples of ROWS SINCE</a></li> </ul> </li> -<li><a href="#rows_since_function">7.105. ROWS SINCE Function</a> +<li><a href="#rows_since_changed_function">7.98. ROWS SINCE CHANGED Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rows_since">7.105.1. Considerations for ROWS SINCE</a></li> -<li><a href="#examples_of_rows_since">7.105.2. Examples of ROWS SINCE</a></li> +<li><a href="#considerations_for_rows_since_changed">7.98.1. Considerations for ROWS SINCE CHANGED</a></li> +<li><a href="#examples_of_rows_since_changed">7.98.2. Examples of ROWS SINCE CHANGED</a></li> </ul> </li> -<li><a href="#rows_since_changed_function">7.106. ROWS SINCE CHANGED Function</a> +<li><a href="#rpad_function">7.99. RPAD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rows_since_changed">7.106.1. Considerations for ROWS SINCE CHANGED</a></li> -<li><a href="#examples_of_rows_since_changed">7.106.2. Examples of ROWS SINCE CHANGED</a></li> +<li><a href="#examples_of_rpad_function">7.99.1. Examples of RPAD Function</a></li> </ul> </li> -<li><a href="#rpad_function">7.107. RPAD Function</a> +<li><a href="#rtrim_function">7.100. RTRIM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_rpad_function">7.107.1. Examples of RPAD Function</a></li> +<li><a href="#considerations_for_rtrim">7.100.1. Considerations for RTRIM</a></li> +<li><a href="#examples_of_rtrim">7.100.2. Examples of RTRIM</a></li> </ul> </li> -<li><a href="#rtrim_function">7.108. RTRIM Function</a> +<li><a href="#runningavg_function">7.101. RUNNINGAVG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rtrim">7.108.1. Considerations for RTRIM</a></li> -<li><a href="#examples_of_rtrim">7.108.2. Examples of RTRIM</a></li> +<li><a href="#considerations_for_runningavg">7.101.1. Considerations for RUNNINGAVG</a></li> +<li><a href="#examples_of_runningavg">7.101.2. Examples of RUNNINGAVG</a></li> </ul> </li> -<li><a href="#runningavg_function">7.109. RUNNINGAVG Function</a> +<li><a href="#runningcount_function">7.102. RUNNINGCOUNT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningavg">7.109.1. Considerations for RUNNINGAVG</a></li> -<li><a href="#examples_of_runningavg">7.109.2. Examples of RUNNINGAVG</a></li> +<li><a href="#considerations_for_runningcount">7.102.1. Considerations for RUNNINGCOUNT</a></li> +<li><a href="#examples_of_runningcount">7.102.2. Examples of RUNNINGCOUNT</a></li> </ul> </li> -<li><a href="#runningcount_function">7.110. RUNNINGCOUNT Function</a> +<li><a href="#runningmax_function">7.103. RUNNINGMAX Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningcount">7.110.1. Considerations for RUNNINGCOUNT</a></li> -<li><a href="#examples_of_runningcount">7.110.2. Examples of RUNNINGCOUNT</a></li> +<li><a href="#examples_of_runningmax">7.103.1. Examples of RUNNINGMAX</a></li> </ul> </li> -<li><a href="#runningmax_function">7.111. RUNNINGMAX Function</a> +<li><a href="#runningmin_function">7.104. RUNNINGMIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningmax">7.111.1. Examples of RUNNINGMAX</a></li> +<li><a href="#examples_of_runningmin">7.104.1. Examples of RUNNINGMIN</a></li> +<li><a href="#runningstddev_function">7.104.2. RUNNINGSTDDEV Function</a></li> +<li><a href="#considerations_for_runningstddev">7.104.3. Considerations for RUNNINGSTDDEV</a></li> +<li><a href="#examples_of_runningstddev">7.104.4. Examples of RUNNINGSTDDEV</a></li> </ul> </li> -<li><a href="#runningmin_function">7.112. RUNNINGMIN Function</a> +<li><a href="#runningsum_function">7.105. RUNNINGSUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningmin">7.112.1. Examples of RUNNINGMIN</a></li> -<li><a href="#runningstddev_function">7.112.2. RUNNINGSTDDEV Function</a></li> -<li><a href="#considerations_for_runningstddev">7.112.3. Considerations for RUNNINGSTDDEV</a></li> -<li><a href="#examples_of_runningstddev">7.112.4. Examples of RUNNINGSTDDEV</a></li> +<li><a href="#examples_of_runningsum">7.105.1. Examples of RUNNINGSUM</a></li> </ul> </li> -<li><a href="#runningsum_function">7.113. RUNNINGSUM Function</a> +<li><a href="#runningvariance_function">7.106. RUNNINGVARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningsum">7.113.1. Examples of RUNNINGSUM</a></li> +<li><a href="#examples_of_runningvariance">7.106.1. Examples of RUNNINGVARIANCE</a></li> </ul> </li> -<li><a href="#runningvariance_function">7.114. RUNNINGVARIANCE Function</a> +<li><a href="#second_function">7.107. SECOND Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningvariance">7.114.1. Examples of RUNNINGVARIANCE</a></li> +<li><a href="#examples_of_second">7.107.1. Examples of SECOND</a></li> </ul> </li> -<li><a href="#second_function">7.115. SECOND Function</a> +<li><a href="#sha_function">7.108. SHA Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_second">7.115.1. Examples of SECOND</a></li> +<li><a href="#examples_of_sha">7.108.1. examples of SHA</a></li> </ul> </li> -<li><a href="#sha_function">7.116. SHA Function</a> +<li><a href="#sha2_function">7.109. SHA2 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sha">7.116.1. examples of SHA</a></li> +<li><a href="#examples_of_sha2">7.109.1. examples of SHA2</a></li> </ul> </li> -<li><a href="#sha2_function">7.117. SHA2 Function</a> +<li><a href="#sign_function">7.110. SIGN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sha2">7.117.1. examples of SHA2</a></li> +<li><a href="#examples_of_sign">7.110.1. Examples of SIGN</a></li> </ul> </li> -<li><a href="#sign_function">7.118. SIGN Function</a> +<li><a href="#sin_function">7.111. SIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sign">7.118.1. Examples of SIGN</a></li> +<li><a href="#examples_of_sin">7.111.1. Examples of SIN</a></li> </ul> </li> -<li><a href="#sin_function">7.119. SIN Function</a> +<li><a href="#sinh_function">7.112. SINH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sin">7.119.1. Examples of SIN</a></li> +<li><a href="#examples_of_sinh">7.112.1. Examples of SINH</a></li> +<li><a href="#space_function">7.112.2. SPACE Function</a></li> +<li><a href="#examples_of_space">7.112.3. Examples of SPACE</a></li> </ul> </li> -<li><a href="#sinh_function">7.120. SINH Function</a> +<li><a href="#sqrt_function">7.113. SQRT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sinh">7.120.1. Examples of SINH</a></li> -<li><a href="#space_function">7.120.2. SPACE Function</a></li> -<li><a href="#examples_of_space">7.120.3. Examples of SPACE</a></li> +<li><a href="#examples_of_sqrt">7.113.1. Examples of SQRT</a></li> </ul> </li> -<li><a href="#sqrt_function">7.121. SQRT Function</a> +<li><a href="#stddev_function">7.114. STDDEV Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sqrt">7.121.1. Examples of SQRT</a></li> +<li><a href="#considerations_for_stddev">7.114.1. Considerations for STDDEV</a></li> +<li><a href="#examples_of_stddev">7.114.2. Examples of STDDEV</a></li> </ul> </li> -<li><a href="#stddev_function">7.122. STDDEV Function</a> +<li><a href="#stringtolob_function">7.115. STRINGTOLOB Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_stddev">7.122.1. Considerations for STDDEV</a></li> -<li><a href="#examples_of_stddev">7.122.2. Examples of STDDEV</a></li> +<li><a href="#stringtolob_function_syntax">7.115.1. Syntax Descriptions of STRINGTOLOB Function</a></li> +<li><a href="#stringtolob_function_examples">7.115.2. Examples of STRINGTOLOB Function</a></li> </ul> </li> -<li><a href="#stringtolob_function">7.123. STRINGTOLOB Function</a> +<li><a href="#substring_function">7.116. SUBSTRING/SUBSTR Function</a> <ul class="sectlevel3"> -<li><a href="#stringtolob_function_syntax">7.123.1. Syntax Descriptions of STRINGTOLOB Function</a></li> -<li><a href="#stringtolob_function_examples">7.123.2. Examples of STRINGTOLOB Function</a></li> +<li><a href="#alternative_forms">7.116.1. Alternative Forms</a></li> +<li><a href="#considerations_for_substring">7.116.2. Considerations for SUBSTRING/SUBSTR</a></li> +<li><a href="#examples_of_substring">7.116.3. Examples of SUBSTRING/SUBSTR</a></li> </ul> </li> -<li><a href="#substring_function">7.124. SUBSTRING/SUBSTR Function</a> +<li><a href="#sum_function">7.117. SUM Function</a> <ul class="sectlevel3"> -<li><a href="#alternative_forms">7.124.1. Alternative Forms</a></li> -<li><a href="#considerations_for_substring">7.124.2. Considerations for SUBSTRING/SUBSTR</a></li> -<li><a href="#examples_of_substring">7.124.3. Examples of SUBSTRING/SUBSTR</a></li> +<li><a href="#considerations_for_sum">7.117.1. Considerations for SUM</a></li> +<li><a href="#examples_of_sum">7.117.2. Examples of SUM</a></li> </ul> </li> -<li><a href="#sum_function">7.125. SUM Function</a> +<li><a href="#sysdate_function">7.118. SYSDATE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_sum">7.125.1. Considerations for SUM</a></li> -<li><a href="#examples_of_sum">7.125.2. Examples of SUM</a></li> +<li><a href="#examples_of_sysdate">7.118.1. Examples of SYSDATE</a></li> </ul> </li> -<li><a href="#sysdate_function">7.126. SYSDATE Function</a> +<li><a href="#systimestamp_function">7.119. SYSTIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sysdate">7.126.1. Examples of SYSDATE</a></li> +<li><a href="#examples_of_systimestamp">7.119.1. Examples of SYSTIMESTAMP</a></li> </ul> </li> -<li><a href="#systimestamp_function">7.127. SYSTIMESTAMP Function</a> +<li><a href="#tan_function">7.120. TAN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_systimestamp">7.127.1. Examples of SYSTIMESTAMP</a></li> +<li><a href="#examples_of_tan">7.120.1. Examples of TAN</a></li> +<li><a href="#tanh_function">7.120.2. TANH Function</a></li> +<li><a href="#examples_of_tanh">7.120.3. Examples of TANH</a></li> </ul> </li> -<li><a href="#tan_function">7.128. TAN Function</a> +<li><a href="#this_function">7.121. THIS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_tan">7.128.1. Examples of TAN</a></li> -<li><a href="#tanh_function">7.128.2. TANH Function</a></li> -<li><a href="#examples_of_tanh">7.128.3. Examples of TANH</a></li> +<li><a href="#considerations_for_this">7.121.1. Considerations for THIS</a></li> +<li><a href="#examples_of_this">7.121.2. Examples of THIS</a></li> </ul> </li> -<li><a href="#this_function">7.129. THIS Function</a> +<li><a href="#timestampadd_function">7.122. TIMESTAMPADD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_this">7.129.1. Considerations for THIS</a></li> -<li><a href="#examples_of_this">7.129.2. Examples of THIS</a></li> +<li><a href="#examples_of_timestampadd">7.122.1. Examples of TIMESTAMPADD</a></li> </ul> </li> -<li><a href="#timestampadd_function">7.130. TIMESTAMPADD Function</a> +<li><a href="#timestampdiff_function">7.123. TIMESTAMPDIFF Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampadd">7.130.1. Examples of TIMESTAMPADD</a></li> +<li><a href="#examples_of_timestampdiff">7.123.1. Examples of TIMESTAMPDIFF</a></li> </ul> </li> -<li><a href="#timestampdiff_function">7.131. TIMESTAMPDIFF Function</a> +<li><a href="#to_char_function">7.124. TO_CHAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampdiff">7.131.1. Examples of TIMESTAMPDIFF</a></li> +<li><a href="#to_char_syntax">7.124.1. Syntax Description of TO_CHAR</a></li> +<li><a href="#considerations_for_to_char">7.124.2. Considerations for TO_CHAR</a></li> +<li><a href="#examples_of_to_char">7.124.3. Examples of TO_CHAR</a></li> </ul> </li> -<li><a href="#to_char_function">7.132. TO_CHAR Function</a> +<li><a href="#to_date_function">7.125. TO_DATE Function</a> <ul class="sectlevel3"> -<li><a href="#to_char_syntax">7.132.1. Syntax Description of TO_CHAR</a></li> -<li><a href="#considerations_for_to_char">7.132.2. Considerations for TO_CHAR</a></li> -<li><a href="#examples_of_to_char">7.132.3. Examples of TO_CHAR</a></li> +<li><a href="#considerations_for_to_date">7.125.1. Considerations for TO_DATE</a></li> +<li><a href="#examples_of_to_date">7.125.2. Examples of TO_DATE</a></li> </ul> </li> -<li><a href="#to_date_function">7.133. TO_DATE Function</a> +<li><a href="#to_time_function">7.126. TO_TIME Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_to_date">7.133.1. Considerations for TO_DATE</a></li> -<li><a href="#examples_of_to_date">7.133.2. Examples of TO_DATE</a></li> +<li><a href="#examples_of_to_time">7.126.1. Examples of TO_TIME</a></li> </ul> </li> -<li><a href="#to_time_function">7.134. TO_TIME Function</a> +<li><a href="#to_timestamp_function">7.127. TO_TIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_time">7.134.1. Examples of TO_TIME</a></li> +<li><a href="#examples_of_to_timestamp">7.127.1. Example of TO_TIMESTAMP</a></li> </ul> </li> -<li><a href="#to_timestamp_function">7.135. TO_TIMESTAMP Function</a> +<li><a href="#translate_function">7.128. TRANSLATE Function</a></li> +<li><a href="#trim_function">7.129. TRIM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_timestamp">7.135.1. Example of TO_TIMESTAMP</a></li> +<li><a href="#considerations_for_trim">7.129.1. Considerations for TRIM</a></li> +<li><a href="#examples_of_trim">7.129.2. Examples of TRIM</a></li> </ul> </li> -<li><a href="#translate_function">7.136. TRANSLATE Function</a></li> -<li><a href="#trim_function">7.137. TRIM Function</a> +<li><a href="#ucase_function">7.130. UCASE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_trim">7.137.1. Considerations for TRIM</a></li> -<li><a href="#examples_of_trim">7.137.2. Examples of TRIM</a></li> +<li><a href="#considerations_for_ucase">7.130.1. Considerations for UCASE</a></li> +<li><a href="#examples_of_ucase">7.130.2. Examples of UCASE</a></li> +<li><a href="#upper_function">7.130.3. UPPER Function</a></li> +<li><a href="#examples_of_upper">7.130.4. Examples of UPPER</a></li> +<li><a href="#upshift_function">7.130.5. UPSHIFT Function</a></li> +<li><a href="#examples_of_upshift">7.130.6. Examples of UPSHIFT</a></li> </ul> </li> -<li><a href="#ucase_function">7.138. UCASE Function</a> +<li><a href="#rand_function">7.131. RAND Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ucase">7.138.1. Considerations for UCASE</a></li> -<li><a href="#examples_of_ucase">7.138.2. Examples of UCASE</a></li> -<li><a href="#upper_function">7.138.3. UPPER Function</a></li> -<li><a href="#examples_of_upper">7.138.4. Examples of UPPER</a></li> -<li><a href="#upshift_function">7.138.5. UPSHIFT Function</a></li> -<li><a href="#examples_of_upshift">7.138.6. Examples of UPSHIFT</a></li> +<li><a href="#rand_function_syntax">7.131.1. Syntax Descriptions of RAND Function</a></li> +<li><a href="#rand_function_considerations">7.131.2. Considerations for RAND Function</a></li> +<li><a href="#rand_function_example">7.131.3. Examples of RAND Function</a></li> </ul> </li> -<li><a href="#rand_function">7.139. RAND Function</a> +<li><a href="#user_function">7.132. USER Function</a> <ul class="sectlevel3"> -<li><a href="#rand_function_syntax">7.139.1. Syntax Descriptions of RAND Function</a></li> -<li><a href="#rand_function_considerations">7.139.2. Considerations for RAND Function</a></li> -<li><a href="#rand_function_example">7.139.3. Examples of RAND Function</a></li> +<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="#user_function">7.140. USER Function</a> -<ul class="sectlevel3"> -<li><a href="#considerations_for_user">7.140.1. Considerations for USER</a></li> -<li><a href="#examples_of_user">7.140.2. Examples of USER</a></li> +<li><a href="#sys_guid_function">7.133. SYS_GUID Function</a> +<ul class="sectlevel4"> +<li><a href="#data_type_of_the_result">Data Type of the Result</a></li> +<li><a href="#examples_of_sys_guid">7.133.2. Examples of SYS_GUID</a></li> </ul> </li> -<li><a href="#variance_function">7.141. VARIANCE Function</a> +<li><a href="#variance_function">7.134. VARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_variance">7.141.1. Considerations for VARIANCE</a></li> -<li><a href="#examples_of_variance">7.141.2. Examples of VARIANCE</a></li> +<li><a href="#considerations_for_variance">7.134.1. Considerations for VARIANCE</a></li> +<li><a href="#examples_of_variance">7.134.2. Examples of VARIANCE</a></li> </ul> </li> -<li><a href="#week_function">7.142. WEEK Function</a> +<li><a href="#week_function">7.135. WEEK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_week">7.142.1. Examples of WEEK</a></li> +<li><a href="#examples_of_week">7.135.1. Examples of WEEK</a></li> </ul> </li> -<li><a href="#year_function">7.143. YEAR Function</a> +<li><a href="#year_function">7.136. YEAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_year">7.143.1. Examples of YEAR</a></li> +<li><a href="#examples_of_year">7.136.1. Examples of YEAR</a></li> </ul> </li> -<li><a href="#zeroifnull_function">7.144. ZEROIFNULL Function</a> +<li><a href="#zeroifnull_function">7.137. ZEROIFNULL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_zeroifnull">7.144.1. Examples of ZEROIFNULL</a></li> +<li><a href="#examples_of_zeroifnull">7.137.1. Examples of ZEROIFNULL</a></li> </ul> </li> </ul> @@ -7160,25 +7163,25 @@ nchar<br> nchar varying<br> national char[acter]<br> national char[acter] varying</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">java.lang.string</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">java.lang.String</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">date</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">java.sql.date</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">java.sql.Date</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">time</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">java.sql.time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">java.sql.Time</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">timestamp</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">java.sql.timestamp</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">java.sql.Timestamp</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">dec<sup class="imal">2</sup><br> pic[ture] s9<sup>3</sup><br> numeric (including numeric with a precision greater than eighteen)<sup>2</sup></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">java.math.bigdecimal</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">java.math.BigDecimal</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">smallint<sup>2</sup></p></td> @@ -7186,23 +7189,23 @@ numeric (including numeric with a precision greater than eighteen)<sup>2</sup></ </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">int<sup class="eger">2</sup></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">int or java.lang.integer<sup>4</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">int or java.lang.Integer<sup>4</sup></p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">largeint<sup>2</sup></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">long or java.lang.long<sup>4</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">long or java.lang.Long<sup>4</sup></p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">float</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">double or java.lang.double<sup>4</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">double or java.lang.Double<sup>4</sup></p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">real</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">float or java.lang.float<sup>4</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">float or java.lang.Float<sup>4</sup></p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">double precision</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">double or java.lang.double<sup>4</sup></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">double or java.lang.Double<sup>4</sup></p></td> </tr> </tbody> </table> @@ -7263,14 +7266,14 @@ If you do not specify the package name, the create procedure statement fails to <p><code>([<em>java-datatype</em>[, <em>java-datatype</em>]…])</code></p> </div> <div class="paragraph"> -<p>The Java signature is necessary only if you want to specify a Java wrapper class (for example, <code>java.lang.integer</code>) instead of a java +<p>The Java signature is necessary only if you want to specify a Java wrapper class (for example, <code>java.lang.Integer</code>) instead of a java primitive data type (for example, <code>int</code>). An SQL data type maps to a Java primitive data type by default.</p> </div> <div class="paragraph"> -<p>The Java signature is case-sensitive and must be placed within parentheses, such as <code>(java.lang.integer, java.lang.integer</code>). +<p>The Java signature is case-sensitive and must be placed within parentheses, such as <code>(java.lang.Integer, java.lang.Integer</code>). The signature must specify each of the parameter data types in the order they appear in the Java method definition within the class file. Each Java data type that corresponds to an out or inout parameter must be followed by empty square -brackets (<code>[ ]</code>), such as <code>java.lang.integer[]</code>.</p> +brackets (<code>[ ]</code>), such as <code>java.lang.Integer[]</code>.</p> </div> <div style="page-break-after: always;"></div> <div class="ulist"> @@ -23126,7 +23129,7 @@ length of 8 bytes.</p></td> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">REAL</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Floating point number (32 bits)</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">+/- 1.17549435e-38 through +/ 3.40282347e+38; stored in 4 bytes</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">+/- 1.17549435e-38 through +/- 3.40282347e+38; stored in 4 bytes</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">DOUBLE PRECISION</p></td> @@ -27385,16 +27388,12 @@ if the following predicate is true:</p> <p>The result of the <code><em>row-value-constructor</em></code> (a row or sequence of values) is equal to any row of column values specified by <code><em>table-subquery</em></code>.</p> -</li> -</ul> -</div> <div class="paragraph"> <p>A table subquery is a query expression and can be specified as a form of a simple table; for example, as the VALUES keyword followed by a list of -row values. See <a href="#select_statement">SELECT Statement</a>.</p> +row values. For more information, see <a href="#select_statement">SELECT Statement</a>.</p> </div> -<div class="ulist"> -<ul> +</li> <li> <p>The result of the <code><em>row-value-constructor</em></code> (a single value) is equal to any of the values specified by the list of expressions @@ -29218,14 +29217,6 @@ clause must be a numeric value or a string value.</p> </div> </li> <li> -<p>The format string 'YYYY-MM_DD' in this example will yield a sample result of 2008-07-17.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SELECT CAST('2008-07-17' AS DATE) (FORMAT 'YYYY-MM-DD') FROM (VALUES(1)) t;</code></pre> -</div> -</div> -</li> -<li> <p>The format string 'MM/DD/YYYY' in this example will yield a sample result of 07/17/2008.</p> <div class="listingblock"> <div class="content"> @@ -29265,30 +29256,6 @@ clause must be a numeric value or a string value.</p> </div> </div> </li> -<li> -<p>The format string 'DD-MMM-YYYY' in this example will yield a sample result of 17âJUL-2008.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SELECT '2008-07-17' (DATE, FORMAT 'DD-MMM-YYYY') FROM (VALUES(1)) t;</code></pre> -</div> -</div> -</li> -<li> -<p>The format string '99:99:99:99' in this example will yield a sample result of 12:34:56:78.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SELECT 12345678 (FORMAT '99:99:99:99') FROM (VALUES(1)) t;</code></pre> -</div> -</div> -</li> -<li> -<p>The format string '-99:99:99:99' in this example will yield a sample result of -12:34:56:78.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SELECT (-12345678) (FORMAT '-99:99:99:99') FROM (VALUES(1)) t;</code></pre> -</div> -</div> -</li> </ul> </div> <div style="page-break-after: always;"></div> @@ -30179,8 +30146,7 @@ in the column list.</p> </div> <div class="paragraph"> <p>In the example TRANSPOSE A,B,C AS V, the items are A,B, and C, and the -value column is V. This form can be thought of as a shorter way of writing TRANSPOSE -(A),(B),© AS (V).</p> +value column is V. This form can be thought of as a shorter way of writing TRANSPOSE (A),(B),(C) AS (V).</p> </div> </li> <li> @@ -31216,24 +31182,53 @@ TRANSPOSE (1, A, 'abc'), (2, B, 'xyz') AS (VALCOL1, VALCOL2, VALCOL3);</code></p <p>This section describes the syntax and semantics of specific functions and expressions that you can use in Trafodion SQL statements. The functions and expressions are categorized according to their -functionality.</p> +functionality:</p> </div> <div class="sect2"> -<h3 id="standard_normalization">7.1. Standard Normalization</h3> +<h3 id="categories">7.1. Categories</h3> <div class="paragraph"> -<p>For datetime functions, the definition of standard normalization is: If -the ending day of the resulting date is invalid, the day will be rounded -DOWN to the last day of the result month.</p> +<p>Use these types of functions within an SQL value expression:</p> </div> +<div class="ulist"> +<ul> +<li> +<p>Aggregate (Set) Functions</p> +</li> +<li> +<p>Character String Functions</p> +</li> +<li> +<p>Datetime Functions</p> +</li> +<li> +<p>LOB Functions</p> +</li> +<li> +<p>Mathematical Functions</p> +</li> +<li> +<p>Encryption Functions</p> +</li> +<li> +<p>Sequence Functions</p> +</li> +<li> +<p>Other Functions and Expressions</p> +</li> +</ul> </div> -<div class="sect2"> -<h3 id="_aggregate_set_functions">7.2. Aggregate (Set) Functions</h3> +<div class="paragraph"> +<p>For more information about SQL value expressions, see <a href="#expressions">Expressions</a>.</p> +</div> +<div class="sect3"> +<h4 id="_aggregate_set_functions">7.1.1. Aggregate (Set) Functions</h4> <div class="paragraph"> <p>An aggregate (or set) function operates on a group or groups of rows retrieved by the SELECT statement or the subquery in which the aggregate function appears.</p> </div> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 1. Overview of Aggregate (Set) Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31280,11 +31275,12 @@ The numbers can be weighted.</p></td> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#sum_function">SUM Function</a></p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Computes the sum of a group of numbers derived from the evaluation of -the expression argument of the function. -"VARIANCE Function" -Computes the statistical variance of a group of numbers derived from the -evaluation of the expression argument of the function. The numbers can -be weighted.</p></td> +the expression argument of the function.</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#variance_function">VARIANCE Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Computes the statistical variance of a group of numbers derived from the +evaluation of the expression argument of the function. The numbers can be weighted.</p></td> </tr> </tbody> </table> @@ -31308,8 +31304,8 @@ list, all rows of the SELECT result table form the one and only group.</p> <p>See the individual entry for the function.</p> </div> </div> -<div class="sect2"> -<h3 id="character_string_functions">7.3. Character String Functions</h3> +<div class="sect3"> +<h4 id="character_string_functions">7.1.2. Character String Functions</h4> <div class="paragraph"> <p>These functions manipulate character strings and use a character value expression as an argument or return a result of a character data type. @@ -31318,6 +31314,7 @@ in an input string as one character, regardless of the byte length of the character.</p> </div> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 2. Overview of Character String Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31345,8 +31342,8 @@ one of the supported character sets.</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#concat_function">CONCAT Function</a></p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Returns the concatenation of two character value expressions as a string -value. You can also use the concatenation operator (||).</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Returns the concatenation of two character value expressions as a string value. +You can also use the concatenation operator.</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#insert_function">INSERT Function</a></p></td> @@ -31449,14 +31446,14 @@ character set.</p></td> <p>See the individual entry for the function.</p> </div> </div> -<div class="sect2"> -<h3 id="datetime_functions">7.4. Datetime Functions</h3> +<div class="sect3"> +<h4 id="datetime_functions">7.1.3. Datetime Functions</h4> <div class="paragraph"> <p>These functions use either a datetime value expression as an argument or return a result of datetime data type:</p> </div> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 7-3 Overview of DATETIME Functions</caption> +<caption class="title">Table 3. Overview of DATETIME Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 50%;"> @@ -31681,12 +31678,13 @@ corresponding week of the year.</p></td> <p>See the individual entry for the function.</p> </div> </div> -<div class="sect2"> -<h3 id="lob_functions">7.5. LOB Functions</h3> +<div class="sect3"> +<h4 id="lob_functions">7.1.4. LOB Functions</h4> <div class="paragraph"> <p>Trafodion provides following LOB functions to process LOB data.</p> </div> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 4. Overview of LOB Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31731,12 +31729,13 @@ corresponding week of the year.</p></td> </tbody> </table> </div> -<div class="sect2"> -<h3 id="mathematical_functions">7.6. Mathematical Functions</h3> +<div class="sect3"> +<h4 id="mathematical_functions">7.1.5. Mathematical Functions</h4> <div class="paragraph"> <p>Use these mathematical functions within an SQL numeric value expression:</p> </div> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 5. Overview of Mathematical Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31857,12 +31856,13 @@ returns 0. If value is greater than zero, returns 1.</p></td> <p>See the individual entry for the function.</p> </div> </div> -<div class="sect2"> -<h3 id="encryption_functions">7.7. Encryption Functions</h3> +<div class="sect3"> +<h4 id="encryption_functions">7.1.6. Encryption Functions</h4> <div class="paragraph"> <p>Use these functions within an SQL value expression to do data encryption or hashing:</p> </div> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 6. Overview of Encryption Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31883,8 +31883,8 @@ returns 0. If value is greater than zero, returns 1.</p></td> </tbody> </table> </div> -<div class="sect2"> -<h3 id="sequence_functions">7.8. Sequence Functions</h3> +<div class="sect3"> +<h4 id="sequence_functions">7.1.7. Sequence Functions</h4> <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 @@ -31900,9 +31900,10 @@ addition, such operations may not be parallelized because the entire 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.8.1. Difference sequence functions</h4> +<div class="sect4"> +<h5 id="difference_sequence_functions">Difference sequence functions</h5> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 7. Overview of Difference Sequence Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31919,9 +31920,10 @@ sequence function.</p> </tbody> </table> </div> -<div class="sect3"> -<h4 id="moving_sequence_functions">7.8.2. Moving sequence functions</h4> +<div class="sect4"> +<h5 id="moving_sequence_functions">Moving sequence functions</h5> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 8. Overview of Moving Sequence Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31953,11 +31955,11 @@ sequence function.</p> </tr> </tbody> </table> -<div class="paragraph"> -<p>Offset sequence function -=== Offset sequence function</p> </div> +<div class="sect4"> +<h5 id="offset_sequence_function">Offset sequence function</h5> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 9. Overview of Offset Sequence Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -31971,9 +31973,10 @@ sequence function.</p> </table> <div style="page-break-after: always;"></div> </div> -<div class="sect3"> -<h4 id="running_sequence_functions">7.8.3. Running sequence functions</h4> +<div class="sect4"> +<h5 id="running_sequence_functions">Running sequence functions</h5> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 10. Overview of Running Sequence Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -32014,9 +32017,10 @@ sequence function.</p> </tbody> </table> </div> -<div class="sect3"> -<h4 id="other_sequence_functions">7.8.4. Other sequence functions</h4> +<div class="sect4"> +<h5 id="other_sequence_functions">Other sequence functions</h5> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 11. Overview of Other Sequence Functions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -32046,12 +32050,13 @@ sequence function.</p> <div style="page-break-after: always;"></div> </div> </div> -<div class="sect2"> -<h3 id="other_functions_and_expressions">7.9. Other Functions and Expressions</h3> +<div class="sect3"> +<h4 id="other_functions_and_expressions">7.1.8. Other Functions and Expressions</h4> <div class="paragraph"> <p>Use these other functions and expressions in an SQL value expression:</p> </div> <table class="tableblock frame-all grid-all spread"> +<caption class="title">Table 12. Overview of Other Functions and Expressions</caption> <colgroup> <col style="width: 25%;"> <col style="width: 75%;"> @@ -32127,15 +32132,28 @@ the expressions have NULL values, the function returns a NULL value.</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Returns either the database user name of the current user who invoked the function or the database user name associated with the specified user ID number.</p></td> </tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#sys_guid_function">SYS_GUID Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">Returns a globally unique identifier.</p></td> +</tr> </tbody> </table> <div class="paragraph"> <p>See the individual entry for the function.</p> </div> +</div> +<div class="sect3"> +<h4 id="standard_normalization">7.1.9. Standard Normalization</h4> +<div class="paragraph"> +<p>For datetime functions, the definition of standard normalization is: If +the ending day of the resulting date is invalid, the day will be rounded +DOWN to the last day of the result month.</p> +</div> <div style="page-break-after: always;"></div> </div> +</div> <div class="sect2"> -<h3 id="abs_function">7.10. ABS Function</h3> +<h3 id="abs_function">7.2. 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> @@ -32160,7 +32178,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.10.1. Examples of ABS</h4> +<h4 id="examples_of_abs">7.2.1. Examples of ABS</h4> <div class="ulist"> <ul> <li> @@ -32177,7 +32195,7 @@ LARGEINT if the precision of the argument is greater than or equal to </div> </div> <div class="sect2"> -<h3 id="acos_function">7.11. ACOS Function</h3> +<h3 id="acos_function">7.3. 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> @@ -32203,7 +32221,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.11.1. Examples of ACOS</h4> +<h4 id="examples_of_acos">7.3.1. Examples of ACOS</h4> <div class="ulist"> <ul> <li> @@ -32229,7 +32247,7 @@ inverse of the function COS.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="add_months_function">7.11.2. ADD_MONTHS Function</h4> +<h4 id="add_months_function">7.3.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 @@ -32275,7 +32293,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.11.3. Examples of ADD_MONTHS</h4> +<h4 id="examples_of_add_months">7.3.3. Examples of ADD_MONTHS</h4> <div class="ulist"> <ul> <li> @@ -32316,7 +32334,7 @@ value) is set to the last valid day of the result month. See </div> </div> <div class="sect2"> -<h3 id="ascii_function">7.12. ASCII Function</h3> +<h3 id="ascii_function">7.4. 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 @@ -32345,7 +32363,7 @@ characters.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_ascii">7.12.1. Considerations For ASCII</h4> +<h4 id="considerations_for_ascii">7.4.1. Considerations For ASCII</h4> <div class="paragraph"> <p>The ASCII function handles string literals and columns differently:</p> </div> @@ -32427,7 +32445,7 @@ characters.</p> <p><strong>Example</strong></p> </div> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 1. UTF8 (with and without error) — Table with One Row</caption> +<caption class="title">Table 13. UTF8 (with and without error) — Table with One Row</caption> <colgroup> <col style="width: 10%;"> <col style="width: 45%;"> @@ -32488,7 +32506,7 @@ characters.</p> </tbody> </table> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 2. UTF8 (with and without error) — Table with Two Rows</caption> +<caption class="title">Table 14. UTF8 (with and without error) — Table with Two Rows</caption> <colgroup> <col style="width: 10%;"> <col style="width: 45%;"> @@ -32552,7 +32570,7 @@ characters.</p> </tbody> </table> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 3. Comparison between UTF8 and ISO88591 (with error) — Table with One Row</caption> +<caption class="title">Table 15. Comparison between UTF8 and ISO88591 (with error) — Table with One Row</caption> <colgroup> <col style="width: 10%;"> <col style="width: 45%;"> @@ -32613,7 +32631,7 @@ characters.</p> </tbody> </table> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 4. Comparison between UTF8 and ISO88591 (without error) — Table with One Row</caption> +<caption class="title">Table 16. Comparison between UTF8 and ISO88591 (without error) — Table with One Row</caption> <colgroup> <col style="width: 10%;"> <col style="width: 45%;"> @@ -32677,7 +32695,7 @@ characters.</p> </tbody> </table> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 5. Comparison between UTF8 and ISO88591 (with error) — Table with Two Rows</caption> +<caption class="title">Table 17. Comparison between UTF8 and ISO88591 (with error) — Table with Two Rows</caption> <colgroup> <col style="width: 10%;"> <col style="width: 45%;"> @@ -32744,7 +32762,7 @@ characters.</p> </ul> </div> <table class="tableblock frame-all grid-all spread"> -<caption class="title">Table 6. Comparison between UTF8 and ISO88591 (without error) — Table with Two Rows</caption> +<caption class="title">Table 18. Comparison between UTF8 and ISO88591 (without error) — Table with Two Rows</caption> <colgroup> <col style="width: 10%;"> <col style="width: 45%;"> @@ -32816,7 +32834,7 @@ characters.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_ascii">7.12.2. Examples of ASCII</h4> +<h4 id="examples_of_ascii">7.4.2. Examples of ASCII</h4> <div class="ulist"> <ul> <li> @@ -32844,7 +32862,7 @@ SALESREP 83 </div> </div> <div class="sect2"> -<h3 id="asin_function">7.13. ASIN Function</h3> +<h3 id="asin_function">7.5. 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> @@ -32870,7 +32888,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.13.1. Considerations for ASCII</h4> +<h4 id="considerations_for_ascii">7.5.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 @@ -32883,7 +32901,7 @@ error message:</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_ascii">7.13.2. Examples of ASCII</h4> +<h4 id="examples_of_ascii">7.5.2. Examples of ASCII</h4> <div class="ulist"> <ul> <li> @@ -32911,7 +32929,7 @@ SALESREP 83 </div> </div> <div class="sect2"> -<h3 id="asin_function">7.14. ASIN Function</h3> +<h3 id="asin_function">7.6. 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> @@ -32937,7 +32955,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.14.1. Examples of ASIN</h4> +<h4 id="examples_of_asin">7.6.1. Examples of ASIN</h4> <div class="ulist"> <ul> <li> @@ -32964,7 +32982,7 @@ inverse of the function SIN.</p> </div> </div> <div class="sect2"> -<h3 id="atan_function">7.15. ATAN Function</h3> +<h3 id="atan_function">7.7. 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> @@ -32989,7 +33007,7 @@ as an angle ex
<TRUNCATED>
