This is an automated email from the ASF dual-hosted git repository.
liuyu pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/trafodion-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 9ddde8e Update Website
9ddde8e is described below
commit 9ddde8e2063f48147bceccca6c15674aeb5f90eb
Author: Yu Liu <[email protected]>
AuthorDate: Sat Mar 30 18:29:37 2019 +0800
Update Website
---
docs/sql_reference/index.html | 1090 ++++++++++++++++++++++++++++-------------
1 file changed, 749 insertions(+), 341 deletions(-)
diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html
index a6520dd..f76767c 100644
--- a/docs/sql_reference/index.html
+++ b/docs/sql_reference/index.html
@@ -537,7 +537,7 @@ table.CodeRay td.code>pre{padding:0}
<div id="header">
<h1>SQL Reference Manual</h1>
<div class="details">
-<span id="revnumber">version 2.4.0</span>
+<span id="revnumber">version </span>
</div>
<div id="toc" class="toc2">
<div id="toctitle">Table of Contents</div>
@@ -1736,347 +1736,353 @@ table.CodeRay td.code>pre{padding:0}
<li><a href="#examples_of_offset">7.92.1. Examples of OFFSET</a></li>
</ul>
</li>
-<li><a href="#pi_function">7.93. PI Function</a>
+<li><a href="#overlay_function">7.93. OVERLAY Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_pi">7.93.1. Examples of PI</a></li>
+<li><a href="#syntax_description_of_overlay">7.93.1. Syntax Description of
OVERLAY</a></li>
+<li><a href="#examples_of_overlay">7.93.2. Examples of OVERLAY</a></li>
</ul>
</li>
-<li><a href="#pivot_function">7.94. PIVOT Function</a>
+<li><a href="#pi_function">7.94. PI Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_description_of_pivot">7.94.1. Syntax Description of
PIVOT</a></li>
-<li><a href="#examples_of_pivot">7.94.2. Examples of PIVOT</a></li>
+<li><a href="#examples_of_pi">7.94.1. Examples of PI</a></li>
</ul>
</li>
-<li><a href="#position_function">7.95. POSITION Function</a>
+<li><a href="#pivot_function">7.95. PIVOT 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="#syntax_description_of_pivot">7.95.1. Syntax Description of
PIVOT</a></li>
+<li><a href="#examples_of_pivot">7.95.2. Examples of PIVOT</a></li>
</ul>
</li>
-<li><a href="#power_function">7.96. POWER Function</a>
+<li><a href="#position_function">7.96. POSITION Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_power">7.96.1. Examples of POWER</a></li>
+<li><a href="#considerations_for_position">7.96.1. Considerations for
POSITION</a></li>
+<li><a href="#examples_of_position">7.96.2. Examples of POSITION</a></li>
</ul>
</li>
-<li><a href="#quarter_function">7.97. QUARTER Function</a>
+<li><a href="#power_function">7.97. POWER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_quarter">7.97.1. Examples of QUARTER</a></li>
+<li><a href="#examples_of_power">7.97.1. Examples of POWER</a></li>
</ul>
</li>
-<li><a href="#radians_function">7.98. RADIANS Function</a>
+<li><a href="#quarter_function">7.98. QUARTER Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_radians">7.98.1. Examples of RADIANS</a></li>
+<li><a href="#examples_of_quarter">7.98.1. Examples of QUARTER</a></li>
</ul>
</li>
-<li><a href="#runningrank_function">7.99. RANK/RUNNINGRANK Function</a>
+<li><a href="#radians_function">7.99. RADIANS 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_radians">7.99.1. Examples of RADIANS</a></li>
</ul>
</li>
-<li><a href="#repeat_function">7.100. REPEAT Function</a>
+<li><a href="#runningrank_function">7.100. RANK/RUNNINGRANK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_repeat">7.100.1. Examples of REPEAT</a></li>
+<li><a href="#considerations_for_runningrank">7.100.1. Considerations for
RANK/RUNNINGRANK</a></li>
+<li><a href="#examples_of_runningrank">7.100.2. Examples of
RANK/RUNNINGRANK</a></li>
</ul>
</li>
-<li><a href="#replace_function">7.101. REPLACE Function</a>
+<li><a href="#repeat_function">7.101. REPEAT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_replace">7.101.1. Examples of REPLACE</a></li>
+<li><a href="#examples_of_repeat">7.101.1. Examples of REPEAT</a></li>
</ul>
</li>
-<li><a href="#right_function">7.102. RIGHT Function</a>
+<li><a href="#replace_function">7.102. REPLACE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_right">7.102.1. Examples of RIGHT</a></li>
+<li><a href="#examples_of_replace">7.102.1. Examples of REPLACE</a></li>
</ul>
</li>
-<li><a href="#rollup_function">7.103. ROLLUP Function</a>
+<li><a href="#right_function">7.103. RIGHT 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_right">7.103.1. Examples of RIGHT</a></li>
</ul>
</li>
-<li><a href="#round_function">7.104. ROUND Function</a>
+<li><a href="#rollup_function">7.104. ROLLUP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_round">7.104.1. Examples of ROUND</a></li>
+<li><a href="#considerations_for_rollup">7.104.1. Considerations for
ROLLUP</a></li>
+<li><a href="#examples_of_rollup">7.104.2. Examples of ROLLUP</a></li>
</ul>
</li>
-<li><a href="#rows_since_function">7.105. ROWS SINCE Function</a>
+<li><a href="#round_function">7.105. ROUND 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="#examples_of_round">7.105.1. Examples of ROUND</a></li>
</ul>
</li>
-<li><a href="#rows_since_changed_function">7.106. ROWS SINCE CHANGED
Function</a>
+<li><a href="#rows_since_function">7.106. ROWS SINCE 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="#considerations_for_rows_since">7.106.1. Considerations for ROWS
SINCE</a></li>
+<li><a href="#examples_of_rows_since">7.106.2. Examples of ROWS SINCE</a></li>
</ul>
</li>
-<li><a href="#rpad_function">7.107. RPAD Function</a>
+<li><a href="#rows_since_changed_function">7.107. ROWS SINCE CHANGED
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_rows_since_changed">7.107.1. Considerations
for ROWS SINCE CHANGED</a></li>
+<li><a href="#examples_of_rows_since_changed">7.107.2. Examples of ROWS SINCE
CHANGED</a></li>
</ul>
</li>
-<li><a href="#rtrim_function">7.108. RTRIM Function</a>
+<li><a href="#rpad_function">7.108. RPAD 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="#examples_of_rpad_function">7.108.1. Examples of RPAD
Function</a></li>
</ul>
</li>
-<li><a href="#runningavg_function">7.109. RUNNINGAVG Function</a>
+<li><a href="#rtrim_function">7.109. RTRIM 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_rtrim">7.109.1. Considerations for
RTRIM</a></li>
+<li><a href="#examples_of_rtrim">7.109.2. Examples of RTRIM</a></li>
</ul>
</li>
-<li><a href="#runningcount_function">7.110. RUNNINGCOUNT Function</a>
+<li><a href="#runningavg_function">7.110. RUNNINGAVG 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="#considerations_for_runningavg">7.110.1. Considerations for
RUNNINGAVG</a></li>
+<li><a href="#examples_of_runningavg">7.110.2. Examples of RUNNINGAVG</a></li>
</ul>
</li>
-<li><a href="#runningmax_function">7.111. RUNNINGMAX Function</a>
+<li><a href="#runningcount_function">7.111. RUNNINGCOUNT Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmax">7.111.1. Examples of RUNNINGMAX</a></li>
+<li><a href="#considerations_for_runningcount">7.111.1. Considerations for
RUNNINGCOUNT</a></li>
+<li><a href="#examples_of_runningcount">7.111.2. Examples of
RUNNINGCOUNT</a></li>
</ul>
</li>
-<li><a href="#runningmin_function">7.112. RUNNINGMIN Function</a>
+<li><a href="#runningmax_function">7.112. RUNNINGMAX Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningmin">7.112.1. Examples of RUNNINGMIN</a></li>
+<li><a href="#examples_of_runningmax">7.112.1. Examples of RUNNINGMAX</a></li>
</ul>
</li>
-<li><a href="#runningstddev_function">7.113. RUNNINGSTDDEV Function</a>
+<li><a href="#runningmin_function">7.113. RUNNINGMIN Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_runningstddev">7.113.1. Considerations for
RUNNINGSTDDEV</a></li>
-<li><a href="#examples_of_runningstddev">7.113.2. Examples of
RUNNINGSTDDEV</a></li>
+<li><a href="#examples_of_runningmin">7.113.1. Examples of RUNNINGMIN</a></li>
</ul>
</li>
-<li><a href="#runningsum_function">7.114. RUNNINGSUM Function</a>
+<li><a href="#runningstddev_function">7.114. RUNNINGSTDDEV Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningsum">7.114.1. Examples of RUNNINGSUM</a></li>
+<li><a href="#considerations_for_runningstddev">7.114.1. Considerations for
RUNNINGSTDDEV</a></li>
+<li><a href="#examples_of_runningstddev">7.114.2. Examples of
RUNNINGSTDDEV</a></li>
</ul>
</li>
-<li><a href="#runningvariance_function">7.115. RUNNINGVARIANCE Function</a>
+<li><a href="#runningsum_function">7.115. RUNNINGSUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_runningvariance">7.115.1. Examples of
RUNNINGVARIANCE</a></li>
+<li><a href="#examples_of_runningsum">7.115.1. Examples of RUNNINGSUM</a></li>
</ul>
</li>
-<li><a href="#reverse_function">7.116. REVERSE Function</a>
+<li><a href="#runningvariance_function">7.116. RUNNINGVARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_description_of_reverse">7.116.1. Syntax Description of
REVERSE</a></li>
-<li><a href="#example_of_reverse">7.116.2. Example of REVERSE</a></li>
+<li><a href="#examples_of_runningvariance">7.116.1. Examples of
RUNNINGVARIANCE</a></li>
</ul>
</li>
-<li><a href="#second_function">7.117. SECOND Function</a>
+<li><a href="#reverse_function">7.117. REVERSE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_second">7.117.1. Examples of SECOND</a></li>
+<li><a href="#syntax_description_of_reverse">7.117.1. Syntax Description of
REVERSE</a></li>
+<li><a href="#example_of_reverse">7.117.2. Example of REVERSE</a></li>
</ul>
</li>
-<li><a href="#sha_function">7.118. SHA Function</a>
+<li><a href="#second_function">7.118. SECOND Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha">7.118.1. examples of SHA</a></li>
+<li><a href="#examples_of_second">7.118.1. Examples of SECOND</a></li>
</ul>
</li>
-<li><a href="#sha2_function">7.119. SHA2 Function</a>
+<li><a href="#sha_function">7.119. SHA Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sha2">7.119.1. examples of SHA2</a></li>
+<li><a href="#examples_of_sha">7.119.1. examples of SHA</a></li>
</ul>
</li>
-<li><a href="#sign_function">7.120. SIGN Function</a>
+<li><a href="#sha2_function">7.120. SHA2 Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sign">7.120.1. Examples of SIGN</a></li>
+<li><a href="#examples_of_sha2">7.120.1. Examples of SHA2</a></li>
</ul>
</li>
-<li><a href="#sin_function">7.121. SIN Function</a>
+<li><a href="#sign_function">7.121. SIGN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sin">7.121.1. Examples of SIN</a></li>
+<li><a href="#examples_of_sign">7.121.1. Examples of SIGN</a></li>
</ul>
</li>
-<li><a href="#sinh_function">7.122. SINH Function</a>
+<li><a href="#sin_function">7.122. SIN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sinh">7.122.1. Examples of SINH</a></li>
+<li><a href="#examples_of_sin">7.122.1. Examples of SIN</a></li>
</ul>
</li>
-<li><a href="#space_function">7.123. SPACE Function</a>
+<li><a href="#sinh_function">7.123. SINH Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_space">7.123.1. Examples of SPACE</a></li>
+<li><a href="#examples_of_sinh">7.123.1. Examples of SINH</a></li>
</ul>
</li>
-<li><a href="#split_part_function">7.124. SPLIT_PART Function</a>
+<li><a href="#space_function">7.124. SPACE Function</a>
<ul class="sectlevel3">
-<li><a href="#syntax_description_of_split_part">7.124.1. Syntax Description of
SPLIT_PART</a></li>
-<li><a href="#example_of_split_part">7.124.2. Example of SPLIT_PART</a></li>
+<li><a href="#examples_of_space">7.124.1. Examples of SPACE</a></li>
</ul>
</li>
-<li><a href="#sqrt_function">7.125. SQRT Function</a>
+<li><a href="#split_part_function">7.125. SPLIT_PART Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sqrt">7.125.1. Examples of SQRT</a></li>
+<li><a href="#syntax_description_of_split_part">7.125.1. Syntax Description of
SPLIT_PART</a></li>
+<li><a href="#examples_of_split_part">7.125.2. Examples of SPLIT_PART</a></li>
</ul>
</li>
-<li><a href="#stddev_function">7.126. STDDEV Function</a>
+<li><a href="#sqrt_function">7.126. SQRT Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_stddev">7.126.1. Considerations for
STDDEV</a></li>
-<li><a href="#examples_of_stddev">7.126.2. Examples of STDDEV</a></li>
+<li><a href="#examples_of_sqrt">7.126.1. Examples of SQRT</a></li>
</ul>
</li>
-<li><a href="#stringtolob_function">7.127. STRINGTOLOB Function</a>
+<li><a href="#stddev_function">7.127. STDDEV Function</a>
<ul class="sectlevel3">
-<li><a href="#stringtolob_function_syntax">7.127.1. Syntax Descriptions of
STRINGTOLOB Function</a></li>
-<li><a href="#stringtolob_function_examples">7.127.2. Examples of STRINGTOLOB
Function</a></li>
+<li><a href="#considerations_for_stddev">7.127.1. Considerations for
STDDEV</a></li>
+<li><a href="#examples_of_stddev">7.127.2. Examples of STDDEV</a></li>
</ul>
</li>
-<li><a href="#substring_function">7.128. SUBSTRING/SUBSTR Function</a>
+<li><a href="#stringtolob_function">7.128. STRINGTOLOB Function</a>
<ul class="sectlevel3">
-<li><a href="#alternative_forms">7.128.1. Alternative Forms</a></li>
-<li><a href="#considerations_for_substring">7.128.2. Considerations for
SUBSTRING/SUBSTR</a></li>
-<li><a href="#examples_of_substring">7.128.3. Examples of
SUBSTRING/SUBSTR</a></li>
+<li><a href="#stringtolob_function_syntax">7.128.1. Syntax Descriptions of
STRINGTOLOB Function</a></li>
+<li><a href="#stringtolob_function_examples">7.128.2. Examples of STRINGTOLOB
Function</a></li>
</ul>
</li>
-<li><a href="#sum_function">7.129. SUM Function</a>
+<li><a href="#substring_function">7.129. SUBSTRING/SUBSTR Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_sum">7.129.1. Considerations for SUM</a></li>
-<li><a href="#examples_of_sum">7.129.2. Examples of SUM</a></li>
+<li><a href="#alternative_forms">7.129.1. Alternative Forms</a></li>
+<li><a href="#considerations_for_substring">7.129.2. Considerations for
SUBSTRING/SUBSTR</a></li>
+<li><a href="#examples_of_substring">7.129.3. Examples of
SUBSTRING/SUBSTR</a></li>
</ul>
</li>
-<li><a href="#sysdate_function">7.130. SYSDATE Function</a>
+<li><a href="#sum_function">7.130. SUM Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sysdate">7.130.1. Examples of SYSDATE</a></li>
+<li><a href="#considerations_for_sum">7.130.1. Considerations for SUM</a></li>
+<li><a href="#examples_of_sum">7.130.2. Examples of SUM</a></li>
</ul>
</li>
-<li><a href="#systimestamp_function">7.131. SYSTIMESTAMP Function</a>
+<li><a href="#sysdate_function">7.131. SYSDATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_systimestamp">7.131.1. Examples of
SYSTIMESTAMP</a></li>
+<li><a href="#examples_of_sysdate">7.131.1. Examples of SYSDATE</a></li>
</ul>
</li>
-<li><a href="#tan_function">7.132. TAN Function</a>
+<li><a href="#systimestamp_function">7.132. SYSTIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_tan">7.132.1. Examples of TAN</a></li>
+<li><a href="#examples_of_systimestamp">7.132.1. Examples of
SYSTIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#tanh_function">7.133. TANH Function</a>
+<li><a href="#tan_function">7.133. TAN Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_tanh">7.133.1. Examples of TANH</a></li>
+<li><a href="#examples_of_tan">7.133.1. Examples of TAN</a></li>
</ul>
</li>
-<li><a href="#this_function">7.134. THIS Function</a>
+<li><a href="#tanh_function">7.134. TANH Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_this">7.134.1. Considerations for
THIS</a></li>
-<li><a href="#examples_of_this">7.134.2. Examples of THIS</a></li>
+<li><a href="#examples_of_tanh">7.134.1. Examples of TANH</a></li>
</ul>
</li>
-<li><a href="#timestampadd_function">7.135. TIMESTAMPADD Function</a>
+<li><a href="#this_function">7.135. THIS Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampadd">7.135.1. Examples of
TIMESTAMPADD</a></li>
+<li><a href="#considerations_for_this">7.135.1. Considerations for
THIS</a></li>
+<li><a href="#examples_of_this">7.135.2. Examples of THIS</a></li>
</ul>
</li>
-<li><a href="#timestampdiff_function">7.136. TIMESTAMPDIFF Function</a>
+<li><a href="#timestampadd_function">7.136. TIMESTAMPADD Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_timestampdiff">7.136.1. Examples of
TIMESTAMPDIFF</a></li>
+<li><a href="#examples_of_timestampadd">7.136.1. Examples of
TIMESTAMPADD</a></li>
</ul>
</li>
-<li><a href="#to_char_function">7.137. TO_CHAR Function</a>
+<li><a href="#timestampdiff_function">7.137. TIMESTAMPDIFF Function</a>
<ul class="sectlevel3">
-<li><a href="#to_char_syntax">7.137.1. Syntax Description of TO_CHAR</a></li>
-<li><a href="#considerations_for_to_char">7.137.2. Considerations for
TO_CHAR</a></li>
-<li><a href="#examples_of_to_char">7.137.3. Examples of TO_CHAR</a></li>
+<li><a href="#examples_of_timestampdiff">7.137.1. Examples of
TIMESTAMPDIFF</a></li>
</ul>
</li>
-<li><a href="#to_date_function">7.138. TO_DATE Function</a>
+<li><a href="#to_char_function">7.138. TO_CHAR Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_to_date">7.138.1. Considerations for
TO_DATE</a></li>
-<li><a href="#examples_of_to_date">7.138.2. Examples of TO_DATE</a></li>
+<li><a href="#to_char_syntax">7.138.1. Syntax Description of TO_CHAR</a></li>
+<li><a href="#considerations_for_to_char">7.138.2. Considerations for
TO_CHAR</a></li>
+<li><a href="#examples_of_to_char">7.138.3. Examples of TO_CHAR</a></li>
</ul>
</li>
-<li><a href="#to_time_function">7.139. TO_TIME Function</a>
+<li><a href="#to_date_function">7.139. TO_DATE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_time">7.139.1. Examples of TO_TIME</a></li>
+<li><a href="#considerations_for_to_date">7.139.1. Considerations for
TO_DATE</a></li>
+<li><a href="#examples_of_to_date">7.139.2. Examples of TO_DATE</a></li>
</ul>
</li>
-<li><a href="#to_timestamp_function">7.140. TO_TIMESTAMP Function</a>
+<li><a href="#to_time_function">7.140. TO_TIME Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_to_timestamp">7.140.1. Example of
TO_TIMESTAMP</a></li>
+<li><a href="#examples_of_to_time">7.140.1. Examples of TO_TIME</a></li>
</ul>
</li>
-<li><a href="#translate_function">7.141. TRANSLATE Function</a></li>
-<li><a href="#trim_function">7.142. TRIM Function</a>
+<li><a href="#to_timestamp_function">7.141. TO_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_trim">7.142.1. Considerations for
TRIM</a></li>
-<li><a href="#examples_of_trim">7.142.2. Examples of TRIM</a></li>
+<li><a href="#examples_of_to_timestamp">7.141.1. Example of
TO_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#ucase_function">7.143. UCASE Function</a>
+<li><a href="#translate_function">7.142. TRANSLATE Function</a></li>
+<li><a href="#trim_function">7.143. TRIM Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_ucase">7.143.1. Considerations for
UCASE</a></li>
-<li><a href="#examples_of_ucase">7.143.2. Examples of UCASE</a></li>
+<li><a href="#considerations_for_trim">7.143.1. Considerations for
TRIM</a></li>
+<li><a href="#examples_of_trim">7.143.2. Examples of TRIM</a></li>
</ul>
</li>
-<li><a href="#upper_function">7.144. UPPER Function</a>
+<li><a href="#ucase_function">7.144. UCASE Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_upper">7.144.1. Examples of UPPER</a></li>
-<li><a href="#upshift_function">7.144.2. UPSHIFT Function</a></li>
-<li><a href="#examples_of_upshift">7.144.3. Examples of UPSHIFT</a></li>
+<li><a href="#considerations_for_ucase">7.144.1. Considerations for
UCASE</a></li>
+<li><a href="#examples_of_ucase">7.144.2. Examples of UCASE</a></li>
</ul>
</li>
-<li><a href="#rand_function">7.145. RAND Function</a>
+<li><a href="#upper_function">7.145. UPPER Function</a>
<ul class="sectlevel3">
-<li><a href="#rand_function_syntax">7.145.1. Syntax Descriptions of RAND
Function</a></li>
-<li><a href="#rand_function_considerations">7.145.2. Considerations for RAND
Function</a></li>
-<li><a href="#rand_function_example">7.145.3. Examples of RAND
Function</a></li>
+<li><a href="#examples_of_upper">7.145.1. Examples of UPPER</a></li>
+<li><a href="#upshift_function">7.145.2. UPSHIFT Function</a></li>
+<li><a href="#examples_of_upshift">7.145.3. Examples of UPSHIFT</a></li>
</ul>
</li>
-<li><a href="#user_function">7.146. USER Function</a>
+<li><a href="#rand_function">7.146. RAND Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_user">7.146.1. Considerations for
USER</a></li>
-<li><a href="#examples_of_user">7.146.2. Examples of USER</a></li>
+<li><a href="#rand_function_syntax">7.146.1. Syntax Descriptions of RAND
Function</a></li>
+<li><a href="#rand_function_considerations">7.146.2. Considerations for RAND
Function</a></li>
+<li><a href="#rand_function_example">7.146.3. Examples of RAND
Function</a></li>
</ul>
</li>
-<li><a href="#sys_guid_function">7.147. SYS_GUID Function</a>
+<li><a href="#user_function">7.147. USER Function</a>
+<ul class="sectlevel3">
+<li><a href="#considerations_for_user">7.147.1. Considerations for
USER</a></li>
+<li><a href="#examples_of_user">7.147.2. Examples of USER</a></li>
+</ul>
+</li>
+<li><a href="#sys_guid_function">7.148. 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.147.2. Examples of SYS_GUID</a></li>
+<li><a href="#examples_of_sys_guid">7.148.2. Examples of SYS_GUID</a></li>
</ul>
</li>
-<li><a href="#uuid_function">7.148. UUID Function</a>
+<li><a href="#uuid_function">7.149. UUID 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_uuid">7.148.2. Examples of UUID</a></li>
+<li><a href="#examples_of_uuid">7.149.2. Examples of UUID</a></li>
</ul>
</li>
-<li><a href="#uuid_short_function">7.149. UUID_SHORT Function</a>
+<li><a href="#uuid_short_function">7.150. UUID_SHORT 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_uuid_short">7.149.2. Examples of UUID_SHORT</a></li>
+<li><a href="#examples_of_uuid_short">7.150.2. Examples of UUID_SHORT</a></li>
</ul>
</li>
-<li><a href="#sleep_function">7.150. SLEEP Function</a>
+<li><a href="#sleep_function">7.151. SLEEP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_sleep">7.150.1. Examples of SLEEP</a></li>
+<li><a href="#examples_of_sleep">7.151.1. Examples of SLEEP</a></li>
</ul>
</li>
-<li><a href="#variance_function">7.151. VARIANCE Function</a>
+<li><a href="#variance_function">7.152. VARIANCE Function</a>
<ul class="sectlevel3">
-<li><a href="#considerations_for_variance">7.151.1. Considerations for
VARIANCE</a></li>
-<li><a href="#examples_of_variance">7.151.2. Examples of VARIANCE</a></li>
+<li><a href="#considerations_for_variance">7.152.1. Considerations for
VARIANCE</a></li>
+<li><a href="#examples_of_variance">7.152.2. Examples of VARIANCE</a></li>
</ul>
</li>
-<li><a href="#week_function">7.152. WEEK Function</a>
+<li><a href="#week_function">7.153. WEEK Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_week">7.152.1. Examples of WEEK</a></li>
+<li><a href="#examples_of_week">7.153.1. Examples of WEEK</a></li>
</ul>
</li>
-<li><a href="#year_function">7.153. YEAR Function</a>
+<li><a href="#year_function">7.154. YEAR Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_year">7.153.1. Examples of YEAR</a></li>
+<li><a href="#examples_of_year">7.154.1. Examples of YEAR</a></li>
</ul>
</li>
-<li><a href="#unix_timestamp_function">7.154. UNIX_TIMESTAMP Function</a>
+<li><a href="#unix_timestamp_function">7.155. UNIX_TIMESTAMP Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_unix_timestamp">7.154.1. Examples of
UNIX_TIMESTAMP</a></li>
+<li><a href="#examples_of_unix_timestamp">7.155.1. Examples of
UNIX_TIMESTAMP</a></li>
</ul>
</li>
-<li><a href="#zeroifnull_function">7.155. ZEROIFNULL Function</a>
+<li><a href="#zeroifnull_function">7.156. ZEROIFNULL Function</a>
<ul class="sectlevel3">
-<li><a href="#examples_of_zeroifnull">7.155.1. Examples of ZEROIFNULL</a></li>
+<li><a href="#examples_of_zeroifnull">7.156.1. Examples of ZEROIFNULL</a></li>
</ul>
</li>
</ul>
@@ -25849,13 +25855,15 @@ delimited identifier.</p>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">GENERATED [ALWAYS | BY
DEFAULT] AS IDENTITY
+(
[START WITH integer]
[INCREMENT BY integer]
[MAXVALUE integer | NOMAXVALUE]
[MINVALUE integer]
[CYCLE | NO CYCLE]
[CACHE integer | NO CACHE]
-[DATA TYPE]</code></pre>
+[DATA TYPE]
+)</code></pre>
</div>
</div>
<div class="sect3">
@@ -25885,23 +25893,85 @@ delimited identifier.</p>
<div class="ulist">
<ul>
<li>
-<p>Example of <code>ALWAYS</code>.</p>
+<p>This example shows how to use the identity column to automatically
genereate an increasing sequential numeric value for the column
<em>employee_id</em>.</p>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">CREATE TABLE
identity_employee (
- id LARGEINT GENERATED ALWAYS AS IDENTITY,
- description VARCHAR(40)
+<pre class="CodeRay highlight"><code data-lang="text">CREATE TABLE
identity_employee
+(
+ employee_id LARGEINT GENERATED ALWAYS AS IDENTITY
+(
+ START WITH 1
+ INCREMENT BY 3
+ MAXVALUE 9999
+ MINVALUE 1
+ NO CYCLE
+ CACHE 30
+),
+ employee_name VARCHAR(40)
);
-SQL>INSERT INTO identity_employee (description) VALUES ('Just DESCRIPTION');
+--- SQL operation complete.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (employee_name)
+VALUES
+('Kevin'),
+('Andy'),
+('Eason'),
+('Magic'),
+('William'),
+('Aven');
---- 1 row(s) inserted.
+--- 6 row(s) inserted.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT * FROM
identity_employee;
-SQL>INSERT INTO identity_employee (id, description) VALUES(NULL, 'ID=NULL
and DESCRIPTION');
+EMPLOYEE_ID EMPLOYEE_NAME
+-------------------- ----------------------------------------
+ 1 Kevin
+ 4 Andy
+ 7 Eason
+ 10 Magic
+ 13 William
+ 16 Aven
-*** ERROR[4122] NULL cannot be assigned to NOT NULL column
TRAFODION.SEBASE.IDENTITY_EMPLOYEE.ID.
+--- 6 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>Example of <code>ALWAYS</code>.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">CREATE TABLE
identity_employee
+(
+ id LARGEINT GENERATED ALWAYS AS IDENTITY,
+ description VARCHAR(40)
+);</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (description) VALUES ('Just DESCRIPTION');
-SQL>INSERT INTO identity_employee (id, description) VALUES(999, 'ID=999 and
DESCRIPTION');
+--- 1 row(s) inserted.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (id, description) VALUES (NULL, 'ID=NULL and DESCRIPTION');
+
+*** ERROR[4122] NULL cannot be assigned to NOT NULL column
TRAFODION.SEABASE.IDENTITY_EMPLOYEE.ID.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (id, description) VALUES (999, 'ID=999 and DESCRIPTION');
*** ERROR[3428] IDENTITY column ID defined as GENERATED ALWAYS cannot accept
values specified by the user.</code></pre>
</div>
@@ -25911,20 +25981,30 @@ SQL>INSERT INTO identity_employee (id,
description) VALUES(999, 'ID=999 and D
<p>Example of <code>BY DEFAULT</code>.</p>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">CREATE TABLE
identity_employee (
+<pre class="CodeRay highlight"><code data-lang="text">CREATE TABLE
identity_employee
+(
id LARGEINT GENERATED BY DEFAULT AS IDENTITY,
description VARCHAR(40)
-);
-
-SQL>INSERT INTO identity_employee (description) VALUES ('Just DESCRIPTION');
-
---- 1 row(s) inserted.
-
-SQL>INSERT INTO identity_employee (id, description) VALUES(NULL, 'ID=NULL
and DESCRIPTION');
+);</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (description) VALUES ('Just DESCRIPTION');
-*** ERROR[4122] NULL cannot be assigned to NOT NULL column
TRAFODION.SEBASE.IDENTITY_EMPLOYEE.ID.
+--- 1 row(s) inserted.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (id, description) VALUES (NULL, 'ID=NULL and DESCRIPTION');
-SQL>INSERT INTO identity_employee (id, description) VALUES(999, 'ID=999 and
DESCRIPTION');
+*** ERROR[4122] NULL cannot be assigned to NOT NULL column
TRAFODION.SEBASE.IDENTITY_EMPLOYEE.ID.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO
identity_employee (id, description) VALUES (999, 'ID=999 and DESCRIPTION');
--- 1 row(s) inserted.</code></pre>
</div>
@@ -42145,7 +42225,332 @@ current row does not fall within the result table.</p>
</div>
</div>
<div class="sect2">
-<h3 id="pi_function">7.93. PI Function</h3>
+<h3 id="overlay_function">7.93. OVERLAY Function</h3>
+<div class="paragraph">
+<p>The OVERLAY function replaces some characters of the
<code><em>source-string</em></code> (or the whole
<code><em>source-string</em></code>) with the
<code><em>replacement-string</em></code>.</p>
+</div>
+<div class="paragraph">
+<p>The OVERLAY function is similar to the INSERT function (see <a
href="#insert_function">INSERT Function</a>) except that the arguments are in a
different order and the <code><em>length</em></code> is optional.</p>
+</div>
+<div class="paragraph">
+<p>OVERLAY is a Trafodion SQL extension.</p>
+</div>
+<div class="paragraph">
+<p><code>OVERLAY (<em>source-string</em> PLACING <em>replacement-string</em>
FROM <em>start</em> [FOR <em>length</em>])</code></p>
+</div>
+<div class="sect3">
+<h4 id="syntax_description_of_overlay">7.93.1. Syntax Description of
OVERLAY</h4>
+<div class="ulist">
+<ul>
+<li>
+<p><code><em>source-string</em></code></p>
+<div class="paragraph">
+<p>is the string to be partly (or entirely) overlaid.</p>
+</div>
+</li>
+<li>
+<p><code><em>replacement-string</em></code></p>
+<div class="paragraph">
+<p>is the string to overlay.</p>
+</div>
+</li>
+<li>
+<p><code><em>start</em></code></p>
+<div class="paragraph">
+<p>is the position at which to begin the overlay.</p>
+</div>
+<div class="admonitionblock note">
+<table>
+<tr>
+<td class="icon">
+<i class="fa icon-note" title="Note"></i>
+</td>
+<td class="content">
+The <code><em>start</em></code> must be an integer greater than or equal to 1.
+</td>
+</tr>
+</table>
+</div>
+<div class="admonitionblock note">
+<table>
+<tr>
+<td class="icon">
+<i class="fa icon-note" title="Note"></i>
+</td>
+<td class="content">
+If <code><em>start</em></code> is greater than the length of the
<code><em>source-string</em></code>, then the
<code><em>replacement-string</em></code> is simply appended.
+</td>
+</tr>
+</table>
+</div>
+<div class="paragraph">
+<p><strong>Example</strong></p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY ('writer'
PLACING '_' FROM 10) FROM DUAL;
+
+(EXPR)
+-------------
+writer_
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p><code><em>length</em></code></p>
+<div class="paragraph">
+<p>specifies the number of characters to be replaced from the
<code><em>source-string</em></code>.</p>
+</div>
+<div class="admonitionblock note">
+<table>
+<tr>
+<td class="icon">
+<i class="fa icon-note" title="Note"></i>
+</td>
+<td class="content">
+If the <code><em>length</em></code> is not specified, then it defaults to the
length of the <code><em>replacement-string</em></code>.
+</td>
+</tr>
+</table>
+</div>
+<div class="paragraph">
+<p><strong>Example</strong></p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY ('writer'
PLACING '_' FROM 2) FROM DUAL;
+
+(EXPR)
+-------------
+w_iter
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY ('writer'
PLACING '_' FROM 2 FOR 1) FROM DUAL;
+
+(EXPR)
+-------------
+w_iter
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY ('writer'
PLACING '_' FROM 2 FOR 2) FROM DUAL;
+
+(EXPR)
+-------------
+w_ter
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+<div class="admonitionblock note">
+<table>
+<tr>
+<td class="icon">
+<i class="fa icon-note" title="Note"></i>
+</td>
+<td class="content">
+If the <code><em>length</em></code> is 0, then the
<code><em>replacement-string</em></code> is inserted into the
<code><em>source-string</em></code> without deleting any characters in the
<code><em>source-string</em></code>.
+</td>
+</tr>
+</table>
+</div>
+<div class="paragraph">
+<p><strong>Example</strong></p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY ('writer'
PLACING '_' FROM 2 FOR 0) FROM DUAL;
+
+(EXPR)
+-------------
+w_riter
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect3">
+<h4 id="examples_of_overlay">7.93.2. Examples of OVERLAY</h4>
+<div class="ulist">
+<ul>
+<li>
+<p>The following examples demonstrate how to use the OVERLAY function and
return the corresponding results.</p>
+<table class="tableblock frame-all grid-all spread">
+<colgroup>
+<col style="width: 70%;">
+<col style="width: 30%;">
+</colgroup>
+<tbody>
+<tr>
+<td class="tableblock halign-center valign-top"><p
class="tableblock"><strong>Statement</strong></p></td>
+<td class="tableblock halign-center valign-top"><p
class="tableblock"><strong>Result</strong></p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 2) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">w_iter</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 4) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">wri_er</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 7) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer_</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 10) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer_</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 2 FOR 0) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">w_riter</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 2 FOR 1) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">w_iter</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 2 FOR 3) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">w_er</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 2 FOR 5) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">w_</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 2 FOR 7) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">w_</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '_' FROM 1 FOR 6) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">_</p></td>
+</tr>
+</tbody>
+</table>
+<table class="tableblock frame-all grid-all spread">
+<colgroup>
+<col style="width: 70%;">
+<col style="width: 30%;">
+</colgroup>
+<tbody>
+<tr>
+<td class="tableblock halign-center valign-top"><p
class="tableblock"><strong>Statement</strong></p></td>
+<td class="tableblock halign-center valign-top"><p
class="tableblock"><strong>Result</strong></p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 2) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 2 FOR 0) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 2 FOR 1) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">witer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 2 FOR 3) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">wer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 2 FOR 5) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">w</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 2 FOR 7) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">w</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('writer' PLACING '' FROM 1 FOR 6) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"></td>
+</tr>
+</tbody>
+</table>
+<table class="tableblock frame-all grid-all spread">
+<colgroup>
+<col style="width: 70%;">
+<col style="width: 30%;">
+</colgroup>
+<tbody>
+<tr>
+<td class="tableblock halign-center valign-top"><p
class="tableblock"><strong>Statement</strong></p></td>
+<td class="tableblock halign-center valign-top"><p
class="tableblock"><strong>Result</strong></p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('' PLACING 'writer' FROM 2) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('' PLACING 'writer' FROM 2 FOR 0) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('' PLACING 'writer' FROM 2 FOR 1) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('' PLACING 'writer' FROM 2 FOR 3) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('' PLACING 'writer' FROM 2 FOR 5) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-top"><p class="tableblock">SELECT
OVERLAY ('' PLACING 'writer' FROM 2 FOR 7) FROM DUAL</p></td>
+<td class="tableblock halign-left valign-top"><p
class="tableblock">writer</p></td>
+</tr>
+</tbody>
+</table>
+</li>
+<li>
+<p>This example replaces the word <em>stackoverflow</em> with the word
<em>reddit</em> at 5 position, 13 characters long.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY
('www.stackoverflow.com' PLACING 'reddit' FROM 5 FOR 13) FROM DUAL;
+
+(EXPR)
+------------------------------------------------
+www.reddit.com
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example changes the road name of Münster city, <em>Dunantstraße</em>,
to the <em>Dunantstrasse</em>.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SELECT OVERLAY
('Dunantstraße' PLACING 'ss' FROM 11 FOR 1) FROM DUAL;
+
+(EXPR)
+--------------------------
+Dunantstrasse
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+<div style="page-break-after: always;"></div>
+</div>
+</div>
+<div class="sect2">
+<h3 id="pi_function">7.94. PI Function</h3>
<div class="paragraph">
<p>The PI function returns the constant value of pi as a floating-point
value.</p>
@@ -42159,7 +42564,7 @@ value.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_pi">7.93.1. Examples of PI</h4>
+<h4 id="examples_of_pi">7.94.1. Examples of PI</h4>
<div class="ulist">
<ul>
<li>
@@ -42176,7 +42581,7 @@ value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="pivot_function">7.94. PIVOT Function</h3>
+<h3 id="pivot_function">7.95. PIVOT Function</h3>
<div class="paragraph">
<p>The PIVOT function transposes rows of a table into a column, aggregating
data in the process of the rotation.</p>
</div>
@@ -42187,7 +42592,7 @@ value.</p>
<p><code>PIVOT (<em>source-column</em>[, DELIMITER
'<em>delimiter</em>'])</code></p>
</div>
<div class="sect3">
-<h4 id="syntax_description_of_pivot">7.94.1. Syntax Description of PIVOT</h4>
+<h4 id="syntax_description_of_pivot">7.95.1. Syntax Description of PIVOT</h4>
<div class="ulist">
<ul>
<li>
@@ -42240,7 +42645,8 @@ VENDOR_ID VENDOR_NAME VENDOR_EMAIL
VENDOR_EMAIL_ID
<pre class="CodeRay highlight"><code data-lang="text">SELECT vendor_id,
PIVOT(vendor_email) FROM vendor GROUP BY vendor_id;
VENDOR_ID (EXPR)
----------
--------------------------------------------------------------------------------------------------------------------------------
+--------------------------------------------------------------
+
111 [email protected]
232 [email protected],[email protected]
367 [email protected],[email protected],[email protected]
@@ -42309,7 +42715,7 @@ [email protected]|[email protected]|[email protected]
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_pivot">7.94.2. Examples of PIVOT</h4>
+<h4 id="examples_of_pivot">7.95.2. Examples of PIVOT</h4>
<div class="ulist">
<ul>
<li>
@@ -42365,7 +42771,7 @@ Shop3 W-R-I-T-E-R
</div>
</div>
<div class="sect2">
-<h3 id="position_function">7.95. POSITION Function</h3>
+<h3 id="position_function">7.96. POSITION Function</h3>
<div class="paragraph">
<p>The POSITION function searches for a given substring in a character
string. If the substring is found, Trafodion SQL returns the character
@@ -42405,7 +42811,7 @@ of zero. If <em>substring-expression</em> is not found
in <em>source-expression<
Trafodion SQL returns zero.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_position">7.95.1. Considerations for POSITION</h4>
+<h4 id="considerations_for_position">7.96.1. Considerations for POSITION</h4>
<div class="sect4">
<h5 id="result_of_position">Result of POSITION</h5>
<div class="paragraph">
@@ -42428,7 +42834,7 @@ function) for both the <em>substring-expression</em>
and the <em>source-expressi
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_position">7.95.2. Examples of POSITION</h4>
+<h4 id="examples_of_position">7.96.2. Examples of POSITION</h4>
<div class="ulist">
<ul>
<li>
@@ -42458,7 +42864,7 @@ WHERE POSITION ('SMITH' IN UPSHIFT(empname)) > 0
;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="power_function">7.96. POWER Function</h3>
+<h3 id="power_function">7.97. POWER Function</h3>
<div class="paragraph">
<p>The POWER function returns the value of a numeric value expression
raised to the power of an integer value expression. You can also use the
@@ -42491,7 +42897,7 @@ exponent must be a value with an exact numeric data
type and a scale of zero.</p
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_power">7.96.1. Examples of POWER</h4>
+<h4 id="examples_of_power">7.97.1. Examples of POWER</h4>
<div class="ulist">
<ul>
<li>
@@ -42517,7 +42923,7 @@ the inverse of the function SQRT:</p>
</div>
</div>
<div class="sect2">
-<h3 id="quarter_function">7.97. QUARTER Function</h3>
+<h3 id="quarter_function">7.98. QUARTER Function</h3>
<div class="paragraph">
<p>The QUARTER function converts a DATE or TIMESTAMP expression into an
INTEGER value in the range 1 through 4 that represents the corresponding
@@ -42544,7 +42950,7 @@ TIMESTAMP. See <a
href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_quarter">7.97.1. Examples of QUARTER</h4>
+<h4 id="examples_of_quarter">7.98.1. Examples of QUARTER</h4>
<div class="ulist">
<ul>
<li>
@@ -42568,7 +42974,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="radians_function">7.98. RADIANS Function</h3>
+<h3 id="radians_function">7.99. RADIANS Function</h3>
<div class="paragraph">
<p>The RADIANS function converts a numeric value expression (expressed in
degrees) to the number of radians.</p>
@@ -42594,7 +43000,7 @@ See <a href="#numeric_value_expressions">Numeric Value
Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_radians">7.98.1. Examples of RADIANS</h4>
+<h4 id="examples_of_radians">7.99.1. Examples of RADIANS</h4>
<div class="ulist">
<ul>
<li>
@@ -42620,7 +43026,7 @@ the function RADIANS.</p>
</div>
</div>
<div class="sect2">
-<h3 id="runningrank_function">7.99. RANK/RUNNINGRANK Function</h3>
+<h3 id="runningrank_function">7.100. RANK/RUNNINGRANK Function</h3>
<div class="paragraph">
<p>The RANK/RUNNINGRANK function is a sequence function that returns the
rank of the given value of an intermediate result table ordered by a
@@ -42665,7 +43071,7 @@ rank. The value of RANK advances to the relative
position of the row in
the intermediate result when the value changes.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_runningrank">7.99.1. Considerations for
RANK/RUNNINGRANK</h4>
+<h4 id="considerations_for_runningrank">7.100.1. Considerations for
RANK/RUNNINGRANK</h4>
<div class="sect4">
<h5 id="sequence_order_dependency">Sequence Order Dependency</h5>
<div class="paragraph">
@@ -42688,7 +43094,7 @@ expression.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_runningrank">7.99.2. Examples of RANK/RUNNINGRANK</h4>
+<h4 id="examples_of_runningrank">7.100.2. Examples of RANK/RUNNINGRANK</h4>
<div class="ulist">
<ul>
<li>
@@ -42867,7 +43273,7 @@ i2 rank
</div>
</div>
<div class="sect2">
-<h3 id="repeat_function">7.100. REPEAT Function</h3>
+<h3 id="repeat_function">7.101. REPEAT Function</h3>
<div class="paragraph">
<p>The REPEAT function returns a character string composed of the
evaluation of a character expression repeated a specified number of
@@ -42903,7 +43309,7 @@ be repeated. The number count must be a value greater
than or equal
to zero of exact numeric data type and with a scale of zero.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_repeat">7.100.1. Examples of REPEAT</h4>
+<h4 id="examples_of_repeat">7.101.1. Examples of REPEAT</h4>
<div class="ulist">
<ul>
<li>
@@ -42922,7 +43328,7 @@ Never,Never,Never,Never,Never,</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="replace_function">7.101. REPLACE Function</h3>
+<h3 id="replace_function">7.102. REPLACE Function</h3>
<div class="paragraph">
<p>The REPLACE function returns a character string where all occurrences of
a specified character string in the original string are replaced with
@@ -42951,7 +43357,7 @@ See <a href="#character_value_expressions">Character
Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_replace">7.101.1. Examples of REPLACE</h4>
+<h4 id="examples_of_replace">7.102.1. Examples of REPLACE</h4>
<div class="ulist">
<ul>
<li>
@@ -42994,7 +43400,7 @@ SYSTEM ANAL TDMNET
</div>
</div>
<div class="sect2">
-<h3 id="right_function">7.102. RIGHT Function</h3>
+<h3 id="right_function">7.103. RIGHT Function</h3>
<div class="paragraph">
<p>The RIGHT function returns the rightmost specified number of characters
from a character expression. Every character, including multi-byte
@@ -43030,7 +43436,7 @@ of zero.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_right">7.102.1. Examples of RIGHT</h4>
+<h4 id="examples_of_right">7.103.1. Examples of RIGHT</h4>
<div class="ulist">
<ul>
<li>
@@ -43059,7 +43465,7 @@ SET jobdesc = RIGHT (jobdesc, 12);</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="rollup_function">7.103. ROLLUP Function</h3>
+<h3 id="rollup_function">7.104. ROLLUP Function</h3>
<div class="paragraph">
<p>The ROLLUP function calculates multiple levels of subtotals aggregating
from right to left through the comma-separated list of columns, and provides a
grand total.</p>
</div>
@@ -43106,7 +43512,7 @@ Trafodion does not support CUBE function which works
slightly differently from R
</table>
</div>
<div class="sect3">
-<h4 id="considerations_for_rollup">7.103.1. Considerations for ROLLUP</h4>
+<h4 id="considerations_for_rollup">7.104.1. Considerations for ROLLUP</h4>
<div class="sect4">
<h5 id="null_in_result_sets">NULL in Result Sets</h5>
<div class="ulist">
@@ -43160,7 +43566,7 @@ Trafodion does not support CUBE function which works
slightly differently from R
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_rollup">7.103.2. Examples of ROLLUP</h4>
+<h4 id="examples_of_rollup">7.104.2. Examples of ROLLUP</h4>
<div class="sect4">
<h5 id="examples_of_grouping_by_one_or_multiple_rollup_columns">Examples of
Grouping By One or Multiple Rollup Columns</h5>
<div class="paragraph">
@@ -43446,7 +43852,7 @@ ORDER BY total_revenue;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="round_function">7.104. ROUND Function</h3>
+<h3 id="round_function">7.105. ROUND Function</h3>
<div class="paragraph">
<p>The ROUND function returns the value of <em>numeric_expr</em> rounded to
<em>num</em>
places to the right of the decimal point.</p>
@@ -43487,7 +43893,7 @@ value <em>numeric_expr</em> is rounded toward the
nearest even number.</p>
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_round">7.104.1. Examples of ROUND</h4>
+<h4 id="examples_of_round">7.105.1. Examples of ROUND</h4>
<div class="ulist">
<ul>
<li>
@@ -43560,7 +43966,7 @@ value <em>numeric_expr</em> is rounded toward the
nearest even number.</p>
</div>
</div>
<div class="sect2">
-<h3 id="rows_since_function">7.105. ROWS SINCE Function</h3>
+<h3 id="rows_since_function">7.106. ROWS SINCE Function</h3>
<div class="paragraph">
<p>The ROWS SINCE function is a sequence function that returns the number
of rows counted since the specified condition was last true in the
@@ -43608,7 +44014,7 @@ returns null.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_rows_since">7.105.1. Considerations for ROWS
SINCE</h4>
+<h4 id="considerations_for_rows_since">7.106.1. Considerations for ROWS
SINCE</h4>
<div class="sect4">
<h5 id="counting_the_rows">Counting the Rows</h5>
<div class="paragraph">
@@ -43626,7 +44032,7 @@ Trafodion SQL then goes to the next row as the new
current row.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_rows_since">7.105.2. Examples of ROWS SINCE</h4>
+<h4 id="examples_of_rows_since">7.106.2. Examples of ROWS SINCE</h4>
<div class="ulist">
<ul>
<li>
@@ -43673,7 +44079,7 @@ FROM mining.seqfcn SEQUENCE BY ts;
</div>
</div>
<div class="sect2">
-<h3 id="rows_since_changed_function">7.106. ROWS SINCE CHANGED Function</h3>
+<h3 id="rows_since_changed_function">7.107. ROWS SINCE CHANGED Function</h3>
<div class="paragraph">
<p>The ROWS SINCE CHANGED function is a sequence function that returns the
number of rows counted since the specified set of values last changed in
@@ -43702,7 +44108,7 @@ values of <em>column-expression-list</em> changed.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_rows_since_changed">7.106.1. Considerations for
ROWS SINCE CHANGED</h4>
+<h4 id="considerations_for_rows_since_changed">7.107.1. Considerations for
ROWS SINCE CHANGED</h4>
<div class="sect4">
<h5 id="counting_the_rows">Counting the Rows</h5>
<div class="paragraph">
@@ -43716,7 +44122,7 @@ than the previous row, the count is 1.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_rows_since_changed">7.106.2. Examples of ROWS SINCE
CHANGED</h4>
+<h4 id="examples_of_rows_since_changed">7.107.2. Examples of ROWS SINCE
CHANGED</h4>
<div class="ulist">
<ul>
<li>
@@ -43743,7 +44149,7 @@ FROM mining.seqfcn SEQUENCE BY ts;</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="rpad_function">7.107. RPAD Function</h3>
+<h3 id="rpad_function">7.108. RPAD Function</h3>
<div class="paragraph">
<p>The RPAD function pads the right side of a string with the specified
string. Every character in the string, including multi-byte characters,
@@ -43785,7 +44191,7 @@ string size, the string is truncated.</p>
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_rpad_function">7.107.1. Examples of RPAD Function</h4>
+<h4 id="examples_of_rpad_function">7.108.1. Examples of RPAD Function</h4>
<div class="ulist">
<ul>
<li>
@@ -43842,7 +44248,7 @@ string size, the string is truncated.</p>
</div>
</div>
<div class="sect2">
-<h3 id="rtrim_function">7.108. RTRIM Function</h3>
+<h3 id="rtrim_function">7.109. RTRIM Function</h3>
<div class="paragraph">
<p>The RTRIM function removes trailing spaces from a character string. If
you must remove any leading character other than space, use the TRIM
@@ -43872,7 +44278,7 @@ to trim trailing spaces.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_rtrim">7.108.1. Considerations for RTRIM</h4>
+<h4 id="considerations_for_rtrim">7.109.1. Considerations for RTRIM</h4>
<div class="sect4">
<h5 id="result_of_rtrim">Result of RTRIM</h5>
<div class="paragraph">
@@ -43882,7 +44288,7 @@ fixed length or maximum variable length of
<em>character-expression</em>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_rtrim">7.108.2. Examples of RTRIM</h4>
+<h4 id="examples_of_rtrim">7.109.2. Examples of RTRIM</h4>
<div class="ulist">
<ul>
<li>
@@ -43902,7 +44308,7 @@ fixed length or maximum variable length of
<em>character-expression</em>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="runningavg_function">7.109. RUNNINGAVG Function</h3>
+<h3 id="runningavg_function">7.110. RUNNINGAVG Function</h3>
<div class="paragraph">
<p>The RUNNINGAVG function is a sequence function that returns the average
of non-null values of a column up to and including the current row of an
@@ -43933,7 +44339,7 @@ up to and including the current row.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_runningavg">7.109.1. Considerations for
RUNNINGAVG</h4>
+<h4 id="considerations_for_runningavg">7.110.1. Considerations for
RUNNINGAVG</h4>
<div class="sect4">
<h5 id="equivalent_result">Equivalent Result</h5>
<div class="paragraph">
@@ -43947,7 +44353,7 @@ up to and including the current row.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_runningavg">7.109.2. Examples of RUNNINGAVG</h4>
+<h4 id="examples_of_runningavg">7.110.2. Examples of RUNNINGAVG</h4>
<div class="ulist">
<ul>
<li>
@@ -43976,7 +44382,7 @@ avg_i1
</div>
</div>
<div class="sect2">
-<h3 id="runningcount_function">7.110. RUNNINGCOUNT Function</h3>
+<h3 id="runningcount_function">7.111. RUNNINGCOUNT Function</h3>
<div class="paragraph">
<p>The RUNNINGCOUNT function is a sequence function that returns the number
of rows up to and including the current row of an intermediate result
@@ -44012,7 +44418,7 @@ intermediate result table up to and including the
current row.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_runningcount">7.110.1. Considerations for
RUNNINGCOUNT</h4>
+<h4 id="considerations_for_runningcount">7.111.1. Considerations for
RUNNINGCOUNT</h4>
<div class="sect4">
<h5 id="no_distinct_clause">No DISTINCT Clause</h5>
<div class="paragraph">
@@ -44026,7 +44432,7 @@ duplicate values are counted.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_runningcount">7.110.2. Examples of RUNNINGCOUNT</h4>
+<h4 id="examples_of_runningcount">7.111.2. Examples of RUNNINGCOUNT</h4>
<div class="ulist">
<ul>
<li>
@@ -44055,7 +44461,7 @@ count_i1
</div>
</div>
<div class="sect2">
-<h3 id="runningmax_function">7.111. RUNNINGMAX Function</h3>
+<h3 id="runningmax_function">7.112. RUNNINGMAX Function</h3>
<div class="paragraph">
<p>The RUNNINGMAX function is a sequence function that returns the maximum
of values of a column up to and including the current row of an
@@ -44086,7 +44492,7 @@ and including the current row.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_runningmax">7.111.1. Examples of RUNNINGMAX</h4>
+<h4 id="examples_of_runningmax">7.112.1. Examples of RUNNINGMAX</h4>
<div class="ulist">
<ul>
<li>
@@ -44114,7 +44520,7 @@ max_i1
</div>
</div>
<div class="sect2">
-<h3 id="runningmin_function">7.112. RUNNINGMIN Function</h3>
+<h3 id="runningmin_function">7.113. RUNNINGMIN Function</h3>
<div class="paragraph">
<p>The RUNNINGMIN function is a sequence function that returns the minimum
of values of a column up to and including the current row of an
@@ -44145,7 +44551,7 @@ and including the current row.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_runningmin">7.112.1. Examples of RUNNINGMIN</h4>
+<h4 id="examples_of_runningmin">7.113.1. Examples of RUNNINGMIN</h4>
<div class="ulist">
<ul>
<li>
@@ -44173,7 +44579,7 @@ min_i1
</div>
</div>
<div class="sect2">
-<h3 id="runningstddev_function">7.113. RUNNINGSTDDEV Function</h3>
+<h3 id="runningstddev_function">7.114. RUNNINGSTDDEV Function</h3>
<div class="paragraph">
<p>The RUNNINGSTDDEV function is a sequence function that returns the
standard deviation of non-null values of a column up to and including the
@@ -44205,7 +44611,7 @@ expression.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_runningstddev">7.113.1. Considerations for
RUNNINGSTDDEV</h4>
+<h4 id="considerations_for_runningstddev">7.114.1. Considerations for
RUNNINGSTDDEV</h4>
<div class="sect4">
<h5 id="equivalent_result">Equivalent Result</h5>
<div class="paragraph">
@@ -44220,7 +44626,7 @@ expression.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_runningstddev">7.113.2. Examples of RUNNINGSTDDEV</h4>
+<h4 id="examples_of_runningstddev">7.114.2. Examples of RUNNINGSTDDEV</h4>
<div class="ulist">
<ul>
<li>
@@ -44268,7 +44674,7 @@ FROM mining.seqfcn SEQUENCE BY ts;
</div>
</div>
<div class="sect2">
-<h3 id="runningsum_function">7.114. RUNNINGSUM Function</h3>
+<h3 id="runningsum_function">7.115. RUNNINGSUM Function</h3>
<div class="paragraph">
<p>The RUNNINGSUM function is a sequence function that returns the sum of
non-null values of a column up to and including the current row of an
@@ -44299,7 +44705,7 @@ to and including the current row.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_runningsum">7.114.1. Examples of RUNNINGSUM</h4>
+<h4 id="examples_of_runningsum">7.115.1. Examples of RUNNINGSUM</h4>
<div class="ulist">
<ul>
<li>
@@ -44328,7 +44734,7 @@ sum_i1
</div>
</div>
<div class="sect2">
-<h3 id="runningvariance_function">7.115. RUNNINGVARIANCE Function</h3>
+<h3 id="runningvariance_function">7.116. RUNNINGVARIANCE Function</h3>
<div class="paragraph">
<p>The RUNNINGVARIANCE function is a sequence function that returns the
variance of non-null values of a column up to and including the current
@@ -44359,7 +44765,7 @@ expression.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_runningvariance">7.115.1. Examples of RUNNINGVARIANCE</h4>
+<h4 id="examples_of_runningvariance">7.116.1. Examples of RUNNINGVARIANCE</h4>
<div class="ulist">
<ul>
<li>
@@ -44412,7 +44818,7 @@ FROM mining.seqfcn SEQUENCE BY ts;
</div>
</div>
<div class="sect2">
-<h3 id="reverse_function">7.116. REVERSE Function</h3>
+<h3 id="reverse_function">7.117. REVERSE Function</h3>
<div class="paragraph">
<p>The REVERSE function returns the <code><em>format-string</em></code> in its
reverse order.</p>
</div>
@@ -44423,7 +44829,7 @@ FROM mining.seqfcn SEQUENCE BY ts;
<p><code>REVERSE (<em>format-string</em>)</code></p>
</div>
<div class="sect3">
-<h4 id="syntax_description_of_reverse">7.116.1. Syntax Description of
REVERSE</h4>
+<h4 id="syntax_description_of_reverse">7.117.1. Syntax Description of
REVERSE</h4>
<div class="ulist">
<ul>
<li>
@@ -44484,7 +44890,7 @@ Trailing blanks in the
<code><em>format-string</em></code> become leading blanks
</div>
</div>
<div class="sect3">
-<h4 id="example_of_reverse">7.116.2. Example of REVERSE</h4>
+<h4 id="example_of_reverse">7.117.2. Example of REVERSE</h4>
<div class="ulist">
<ul>
<li>
@@ -44538,7 +44944,7 @@ Writer
</div>
</div>
<div class="sect2">
-<h3 id="second_function">7.117. SECOND Function</h3>
+<h3 id="second_function">7.118. SECOND Function</h3>
<div class="paragraph">
<p>The SECOND function converts a TIME or TIMESTAMP expression into an
INTEGER value in the range 0 through 59 that represents the
@@ -44564,7 +44970,7 @@ TIMESTAMP. See <a
href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_second">7.117.1. Examples of SECOND</h4>
+<h4 id="examples_of_second">7.118.1. Examples of SECOND</h4>
<div class="ulist">
<ul>
<li>
@@ -44588,14 +44994,14 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="sha_function">7.118. SHA Function</h3>
+<h3 id="sha_function">7.119. SHA Function</h3>
<div class="paragraph">
<p>Calculates an SHA-1 160-bit checksum for the string, as described in
RFC 3174 (Secure Hash Algorithm). The value is returned as a string of
40 hexadecimal digits, or NULL if the argument was NULL.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_sha">7.118.1. examples of SHA</h4>
+<h4 id="examples_of_sha">7.119.1. examples of SHA</h4>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">>>SELECT
SHA1('abc') from dual;
@@ -44609,7 +45015,7 @@ RFC 3174 (Secure Hash Algorithm). The value is returned
as a string of
</div>
</div>
<div class="sect2">
-<h3 id="sha2_function">7.119. SHA2 Function</h3>
+<h3 id="sha2_function">7.120. SHA2 Function</h3>
<div class="paragraph">
<p>Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384,
and SHA-512). The first argument is the cleartext string to be hashed.
@@ -44621,7 +45027,7 @@ the desired number of bits. See the notes at the
beginning of this section
about storing hash values efficiently.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_sha2">7.119.1. examples of SHA2</h4>
+<h4 id="examples_of_sha2">7.120.1. Examples of SHA2</h4>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">>>SELECT
SHA2('abc', 224) from dual;
@@ -44635,7 +45041,7 @@ about storing hash values efficiently.</p>
</div>
</div>
<div class="sect2">
-<h3 id="sign_function">7.120. SIGN Function</h3>
+<h3 id="sign_function">7.121. SIGN Function</h3>
<div class="paragraph">
<p>The SIGN function returns an indicator of the sign of a numeric value
expression. If the value is less than zero, the function returns -1 as
@@ -44663,7 +45069,7 @@ See <a href="#numeric_value_expressions">Numeric Value
Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_sign">7.120.1. Examples of SIGN</h4>
+<h4 id="examples_of_sign">7.121.1. Examples of SIGN</h4>
<div class="ulist">
<ul>
<li>
@@ -44696,7 +45102,7 @@ See <a href="#numeric_value_expressions">Numeric Value
Expressions</a>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="sin_function">7.121. SIN Function</h3>
+<h3 id="sin_function">7.122. SIN Function</h3>
<div class="paragraph">
<p>The SIN function returns the SINE of a numeric value expression, where
the expression is an angle expressed in radians.</p>
@@ -44722,7 +45128,7 @@ See <a href="#numeric_value_expressions">Numeric Value
Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_sin">7.121.1. Examples of SIN</h4>
+<h4 id="examples_of_sin">7.122.1. Examples of SIN</h4>
<div class="ulist">
<ul>
<li>
@@ -44740,7 +45146,7 @@ approximately 0.3420, the sine of 0.3491 (which is 20
degrees):</p>
</div>
</div>
<div class="sect2">
-<h3 id="sinh_function">7.122. SINH Function</h3>
+<h3 id="sinh_function">7.123. SINH Function</h3>
<div class="paragraph">
<p>The SINH function returns the hyperbolic sine of a numeric value
expression, where the expression is an angle expressed in radians.</p>
@@ -44766,7 +45172,7 @@ See <a href="#numeric_value_expressions">Numeric Value
Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_sinh">7.122.1. Examples of SINH</h4>
+<h4 id="examples_of_sinh">7.123.1. Examples of SINH</h4>
<div class="ulist">
<ul>
<li>
@@ -44784,7 +45190,7 @@ approximately 1.6019, the hyperbolic sine of 1.25:</p>
</div>
</div>
<div class="sect2">
-<h3 id="space_function">7.123. SPACE Function</h3>
+<h3 id="space_function">7.124. SPACE Function</h3>
<div class="paragraph">
<p>The SPACE function returns a character string consisting of a specified
number of spaces, each of which is 0x20 or 0x0020, depending on the
@@ -44823,7 +45229,7 @@ with the character set specified by
<em>char-set-name</em>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_space">7.123.1. Examples of SPACE</h4>
+<h4 id="examples_of_space">7.124.1. Examples of SPACE</h4>
<div class="ulist">
<ul>
<li>
@@ -44840,7 +45246,7 @@ with the character set specified by
<em>char-set-name</em>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="split_part_function">7.124. SPLIT_PART Function</h3>
+<h3 id="split_part_function">7.125. SPLIT_PART Function</h3>
<div class="paragraph">
<p>The SPLIT_PART function returns the n<sup>th</sup> substring that is split
on the defined <code><em>delimiter</em></code> and
<code><em>field-position</em></code>.</p>
</div>
@@ -44851,7 +45257,7 @@ with the character set specified by
<em>char-set-name</em>.</p>
<p><code>SPLIT_PART (<em>source-string, delimiter,
field-position</em>)</code></p>
</div>
<div class="sect3">
-<h4 id="syntax_description_of_split_part">7.124.1. Syntax Description of
SPLIT_PART</h4>
+<h4 id="syntax_description_of_split_part">7.125.1. Syntax Description of
SPLIT_PART</h4>
<div class="ulist">
<ul>
<li>
@@ -45031,7 +45437,7 @@ The function returns an empty string if the
<code><em>field-position</em></code>
</div>
</div>
<div class="sect3">
-<h4 id="example_of_split_part">7.124.2. Example of SPLIT_PART</h4>
+<h4 id="examples_of_split_part">7.125.2. Examples of SPLIT_PART</h4>
<div class="ulist">
<ul>
<li>
@@ -45177,7 +45583,7 @@ comprehensively 2
</div>
</div>
<div class="sect2">
-<h3 id="sqrt_function">7.125. SQRT Function</h3>
+<h3 id="sqrt_function">7.126. SQRT Function</h3>
<div class="paragraph">
<p>The SQRT function returns the square root of a numeric value expression.
SQRT is a Trafodion SQL extension.</p>
@@ -45200,7 +45606,7 @@ negative number. See <a
href="#numeric_value_expressions">Numeric Value Expressi
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_sqrt">7.125.1. Examples of SQRT</h4>
+<h4 id="examples_of_sqrt">7.126.1. Examples of SQRT</h4>
<div class="ulist">
<ul>
<li>
@@ -45218,7 +45624,7 @@ approximately 5.196:</p>
</div>
</div>
<div class="sect2">
-<h3 id="stddev_function">7.126. STDDEV Function</h3>
+<h3 id="stddev_function">7.127. STDDEV Function</h3>
<div class="paragraph">
<p>STDDEV is an aggregate function that returns the standard deviation of a
set of numbers. STDDEV is a Trafodion SQL extension.</p>
@@ -45264,7 +45670,7 @@ evaluation of <em>weight</em> must have the same
cardinality.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_stddev">7.126.1. Considerations for STDDEV</h4>
+<h4 id="considerations_for_stddev">7.127.1. Considerations for STDDEV</h4>
<div class="sect4">
<h5 id="definition_of_stddev">Definition of STDDEV</h5>
<div class="paragraph">
@@ -45316,7 +45722,7 @@ of STDDEV(x), a numeric overflow occurs.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_stddev">7.126.2. Examples of STDDEV</h4>
+<h4 id="examples_of_stddev">7.127.2. Examples of STDDEV</h4>
<div class="ulist">
<ul>
<li>
@@ -45354,9 +45760,9 @@ inventory:</p>
</div>
</div>
<div class="sect2">
-<h3 id="stringtolob_function">7.127. STRINGTOLOB Function</h3>
+<h3 id="stringtolob_function">7.128. STRINGTOLOB Function</h3>
<div class="sect3">
-<h4 id="stringtolob_function_syntax">7.127.1. Syntax Descriptions of
STRINGTOLOB Function</h4>
+<h4 id="stringtolob_function_syntax">7.128.1. Syntax Descriptions of
STRINGTOLOB Function</h4>
<div class="paragraph">
<p>The STRINGTOLOB function converts a simple string literal into LOB format.
This function can be used in an INSERT or UPDATE statement.</p>
</div>
@@ -45393,7 +45799,7 @@ inventory:</p>
</div>
</div>
<div class="sect3">
-<h4 id="stringtolob_function_examples">7.127.2. Examples of STRINGTOLOB
Function</h4>
+<h4 id="stringtolob_function_examples">7.128.2. Examples of STRINGTOLOB
Function</h4>
<div class="ulist">
<ul>
<li>
@@ -45410,7 +45816,7 @@ inventory:</p>
</div>
</div>
<div class="sect2">
-<h3 id="substring_function">7.128. SUBSTRING/SUBSTR Function</h3>
+<h3 id="substring_function">7.129. SUBSTRING/SUBSTR Function</h3>
<div class="paragraph">
<p>The SUBSTRING function extracts a substring out of a given character
expression. It returns a character string of data type VARCHAR, with a
@@ -45484,7 +45890,7 @@ and continuing until the end of the
<em>character-expr</em> are returned.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="alternative_forms">7.128.1. Alternative Forms</h4>
+<h4 id="alternative_forms">7.129.1. Alternative Forms</h4>
<div class="ulist">
<ul>
<li>
@@ -45512,7 +45918,7 @@ database software already supports SUBSTRING
(<em>string</em>, <em>Fromint</em>,
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_substring">7.128.2. Considerations for
SUBSTRING/SUBSTR</h4>
+<h4 id="considerations_for_substring">7.129.2. Considerations for
SUBSTRING/SUBSTR</h4>
<div class="sect4">
<h5
id="requirements_for_the_expression_length_and_start_position">Requirements for
the Expression, Length, and Start Position</h5>
<div class="ulist">
@@ -45541,7 +45947,7 @@ an up-shifted VARCHAR type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_substring">7.128.3. Examples of SUBSTRING/SUBSTR</h4>
+<h4 id="examples_of_substring">7.129.3. Examples of SUBSTRING/SUBSTR</h4>
<div class="ulist">
<ul>
<li>
@@ -45613,7 +46019,7 @@ SUBSTR ('Robert John Smith' FROM 8 FOR 0)</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="sum_function">7.129. SUM Function</h3>
+<h3 id="sum_function">7.130. SUM Function</h3>
<div class="paragraph">
<p>SUM is an aggregate function that returns the sum of a set of numbers.</p>
</div>
@@ -45648,7 +46054,7 @@ NULL. See <a href="#expressions">Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_sum">7.129.1. Considerations for SUM</h4>
+<h4 id="considerations_for_sum">7.130.1. Considerations for SUM</h4>
<div class="sect4">
<h5 id="data_type_and_scale_of_the_result">Data Type and Scale of the
Result</h5>
<div class="paragraph">
@@ -45678,7 +46084,7 @@ SUM (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_sum">7.129.2. Examples of SUM</h4>
+<h4 id="examples_of_sum">7.130.2. Examples of SUM</h4>
<div class="ulist">
<ul>
<li>
@@ -45701,7 +46107,7 @@ SUM (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="sysdate_function">7.130. SYSDATE Function</h3>
+<h3 id="sysdate_function">7.131. SYSDATE Function</h3>
<div class="paragraph">
<p>The SYSDATE function, which is equivalent to the <code>CURRENT_DATE</code>
function, retrieves the current date of the server rather than the session.</p>
</div>
@@ -45717,7 +46123,7 @@ SUM (PARTCOST * QTY_ORDERED)</code></pre>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_sysdate">7.130.1. Examples of SYSDATE</h4>
+<h4 id="examples_of_sysdate">7.131.1. Examples of SYSDATE</h4>
<div class="ulist">
<ul>
<li>
@@ -45865,7 +46271,7 @@ ORDERNUM ORDER_DATE DELIV_DATE SALESREP CUSTNUM
</div>
</div>
<div class="sect2">
-<h3 id="systimestamp_function">7.131. SYSTIMESTAMP Function</h3>
+<h3 id="systimestamp_function">7.132. SYSTIMESTAMP Function</h3>
<div class="paragraph">
<p>The SYSTIMESTAMP function, which is equivalent to the
<code>CURRENT_TIMESTAMP</code> function, provides much high granularity than
the <code>SYSDATE</code> function and retrieves the current date and time
(including fractional seconds with six-digit precision) of the server rather
than the session.</p>
</div>
@@ -45881,7 +46287,7 @@ ORDERNUM ORDER_DATE DELIV_DATE SALESREP CUSTNUM
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_systimestamp">7.131.1. Examples of SYSTIMESTAMP</h4>
+<h4 id="examples_of_systimestamp">7.132.1. Examples of SYSTIMESTAMP</h4>
<div class="ulist">
<ul>
<li>
@@ -45932,7 +46338,7 @@ C1 C2
</div>
</div>
<div class="sect2">
-<h3 id="tan_function">7.132. TAN Function</h3>
+<h3 id="tan_function">7.133. TAN Function</h3>
<div class="paragraph">
<p>The TAN function returns the tangent of a numeric value expression,
where the expression is an angle expressed in radians.</p>
@@ -45958,7 +46364,7 @@ See <a href="#numeric_value_expressions">Numeric Value
Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_tan">7.132.1. Examples of TAN</h4>
+<h4 id="examples_of_tan">7.133.1. Examples of TAN</h4>
<div class="ulist">
<ul>
<li>
@@ -45976,7 +46382,7 @@ approximately 0.3640, the tangent of 0.3491 (which is
20 degrees):</p>
</div>
</div>
<div class="sect2">
-<h3 id="tanh_function">7.133. TANH Function</h3>
+<h3 id="tanh_function">7.134. TANH Function</h3>
<div class="paragraph">
<p>The TANH function returns the hyperbolic tangent of a numeric value
expression, where the expression is an angle expressed in radians.</p>
@@ -46002,7 +46408,7 @@ function. See <a
href="#numeric_value_expressions">Numeric Value Expressions</a>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_tanh">7.133.1. Examples of TANH</h4>
+<h4 id="examples_of_tanh">7.134.1. Examples of TANH</h4>
<div class="ulist">
<ul>
<li>
@@ -46020,7 +46426,7 @@ approximately 0.8483, the hyperbolic tangent of
1.25:</p>
</div>
</div>
<div class="sect2">
-<h3 id="this_function">7.134. THIS Function</h3>
+<h3 id="this_function">7.135. THIS Function</h3>
<div class="paragraph">
<p>The THIS function is a sequence function that is used in the ROWS SINCE
function to distinguish between the value of the column in the current
@@ -46048,7 +46454,7 @@ expression. If the value of the expression is null,
THIS returns null.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_this">7.134.1. Considerations for THIS</h4>
+<h4 id="considerations_for_this">7.135.1. Considerations for THIS</h4>
<div class="sect4">
<h5 id="counting_the_rows">Counting the Rows</h5>
<div class="paragraph">
@@ -46080,7 +46486,7 @@ THIS constant is reevaluated.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_this">7.134.2. Examples of THIS</h4>
+<h4 id="examples_of_this">7.135.2. Examples of THIS</h4>
<div class="ulist">
<ul>
<li>
@@ -46109,7 +46515,7 @@ rows_since_this
</div>
</div>
<div class="sect2">
-<h3 id="timestampadd_function">7.135. TIMESTAMPADD Function</h3>
+<h3 id="timestampadd_function">7.136. TIMESTAMPADD Function</h3>
<div class="paragraph">
<p>The TIMESTAMPADD function adds the interval of time specified by
<em>interval-ind</em> and <em>num_expr</em> to <em>datetime_expr</em>. If the
specified
@@ -46159,7 +46565,7 @@ returned.</p>
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_timestampadd">7.135.1. Examples of TIMESTAMPADD</h4>
+<h4 id="examples_of_timestampadd">7.136.1. Examples of TIMESTAMPADD</h4>
<div class="ulist">
<ul>
<li>
@@ -46224,7 +46630,7 @@ returned.</p>
</div>
</div>
<div class="sect2">
-<h3 id="timestampdiff_function">7.136. TIMESTAMPDIFF Function</h3>
+<h3 id="timestampdiff_function">7.137. TIMESTAMPDIFF Function</h3>
<div class="paragraph">
<p>The TIMESTAMPDIFF function returns the integer for the number of
<em>interval-ind</em> units of time between <em>startdate</em> and
<em>enddate</em>. If
@@ -46289,7 +46695,7 @@ January 7 of the year 0001.</p>
</div>
<div style="page-break-after: always;"></div>
<div class="sect3">
-<h4 id="examples_of_timestampdiff">7.136.1. Examples of TIMESTAMPDIFF</h4>
+<h4 id="examples_of_timestampdiff">7.137.1. Examples of TIMESTAMPDIFF</h4>
<div class="ulist">
<ul>
<li>
@@ -46353,7 +46759,7 @@ crossed:</p>
</div>
</div>
<div class="sect2">
-<h3 id="to_char_function">7.137. TO_CHAR Function</h3>
+<h3 id="to_char_function">7.138. TO_CHAR Function</h3>
<div class="paragraph">
<p>The TO_CHAR function converts a datetime value to a character value. The
optional
second argument describes the format of the character value.</p>
@@ -46364,7 +46770,7 @@ second argument describes the format of the character
value.</p>
</div>
</div>
<div class="sect3">
-<h4 id="to_char_syntax">7.137.1. Syntax Description of TO_CHAR</h4>
+<h4 id="to_char_syntax">7.138.1. Syntax Description of TO_CHAR</h4>
<div class="ulist">
<ul>
<li>
@@ -47082,7 +47488,7 @@ default for date and timestamp values, and 'HH:MI:SS'
is used for time values.</
</div>
</div>
<div class="sect3">
-<h4 id="considerations_for_to_char">7.137.2. Considerations for TO_CHAR</h4>
+<h4 id="considerations_for_to_char">7.138.2. Considerations for TO_CHAR</h4>
<div class="paragraph">
<p>If the <code><em>format-string</em></code> contains only hour, minute or
seconds fields, the input data type must be time or timestamp.</p>
</div>
@@ -47094,7 +47500,7 @@ default for date and timestamp values, and 'HH:MI:SS'
is used for time values.</
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_to_char">7.137.3. Examples of TO_CHAR</h4>
+<h4 id="examples_of_to_char">7.138.3. Examples of TO_CHAR</h4>
<div class="sect4">
<h5 id="examples_of_to_char_cc">Examples of TO_CHAR (CC)</h5>
<div class="ulist">
@@ -47873,7 +48279,7 @@ NOV
</div>
</div>
<div class="sect2">
-<h3 id="to_date_function">7.138. TO_DATE Function</h3>
+<h3 id="to_date_function">7.139. TO_DATE Function</h3>
<div class="paragraph">
<p>The TO_DATE function converts a character value to a date. The optional
second argument describes the format of the character value.</p>
@@ -47985,14 +48391,14 @@ a three-letter abbreviation for month ('JAN', 'FEB',
'MAR', 'APR', 'MAY', 'JUN',
default.</p>
</div>
<div class="sect3">
-<h4 id="considerations_for_to_date">7.138.1. Considerations for TO_DATE</h4>
+<h4 id="considerations_for_to_date">7.139.1. Considerations for TO_DATE</h4>
<div class="paragraph">
<p>If the <em>format-string</em> contains hour, minute or seconds fields, the
output data type is timestamp. Otherwise,
the output data type is date.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_to_date">7.138.2. Examples of TO_DATE</h4>
+<h4 id="examples_of_to_date">7.139.2. Examples of TO_DATE</h4>
<div class="ulist">
<ul>
<li>
@@ -48033,7 +48439,7 @@ the output data type is date.</p>
</div>
</div>
<div class="sect2">
-<h3 id="to_time_function">7.139. TO_TIME Function</h3>
+<h3 id="to_time_function">7.140. TO_TIME Function</h3>
<div class="paragraph">
<p>The TO_TIME function converts a character value to a time. The
second argument describes the format of the character value.</p>
@@ -48073,7 +48479,7 @@ second argument describes the format of the character
value.</p>
<p>Here, HH and HH24 refer to a 2-digit hour field. MI refers to a two-digit
minutes field. SS refers to a 2-digit seconds field.</p>
</div>
<div class="sect3">
-<h4 id="examples_of_to_time">7.139.1. Examples of TO_TIME</h4>
+<h4 id="examples_of_to_time">7.140.1. Examples of TO_TIME</h4>
<div class="ulist">
<ul>
<li>
@@ -48090,7 +48496,7 @@ second argument describes the format of the character
value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="to_timestamp_function">7.140. TO_TIMESTAMP Function</h3>
+<h3 id="to_timestamp_function">7.141. TO_TIMESTAMP Function</h3>
<div class="paragraph">
<p>The TO_TIMESTAMP function converts a character value to a timestamp.</p>
</div>
@@ -48112,7 +48518,7 @@ minutes field, SS is a two-digit seconds field and
FFFFFF is an optional microse
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_to_timestamp">7.140.1. Example of TO_TIMESTAMP</h4>
+<h4 id="examples_of_to_timestamp">7.141.1. Example of TO_TIMESTAMP</h4>
<div class="ulist">
<ul>
<li>
@@ -48129,7 +48535,7 @@ minutes field, SS is a two-digit seconds field and
FFFFFF is an optional microse
</div>
</div>
<div class="sect2">
-<h3 id="translate_function">7.141. TRANSLATE Function</h3>
+<h3 id="translate_function">7.142. TRANSLATE Function</h3>
<div class="paragraph">
<p>The TRANSLATE function translates a character string from a source
character set to a target character set. The TRANSLATE function changes
@@ -48214,7 +48620,7 @@ Trafodion SQL returns an error.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="trim_function">7.142. TRIM Function</h3>
+<h3 id="trim_function">7.143. TRIM Function</h3>
<div class="paragraph">
<p>The TRIM function removes leading and trailing characters from a
character string. Every character, including multi-byte characters, is
@@ -48261,7 +48667,7 @@ to trim characters. See <a
href="#character_value_expressions">Character Value E
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_trim">7.142.1. Considerations for TRIM</h4>
+<h4 id="considerations_for_trim">7.143.1. Considerations for TRIM</h4>
<div class="sect4">
<h5 id="result_of_trim">Result of TRIM</h5>
<div class="paragraph">
@@ -48274,7 +48680,7 @@ result is an up-shifts VARCHAR type.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_trim">7.142.2. Examples of TRIM</h4>
+<h4 id="examples_of_trim">7.143.2. Examples of TRIM</h4>
<div class="ulist">
<ul>
<li>
@@ -48301,7 +48707,7 @@ CHAR(20). This expression uses the TRIM function to
return the value
</div>
</div>
<div class="sect2">
-<h3 id="ucase_function">7.143. UCASE Function</h3>
+<h3 id="ucase_function">7.144. UCASE Function</h3>
<div class="paragraph">
<p>The UCASE function up-shifts alphanumeric characters. For
non-alphanumeric characters, UCASE returns the same character. UCASE can
@@ -48336,7 +48742,7 @@ characters to upshift. See <a
href="#character_value_expressions">Character Valu
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_ucase">7.143.1. Considerations for UCASE</h4>
+<h4 id="considerations_for_ucase">7.144.1. Considerations for UCASE</h4>
<div class="paragraph">
<p>For a UTF8 character_expression, the UCASE function up-shifts all
lowercase or title case characters to uppercase and returns a character
@@ -48355,7 +48761,7 @@ name includes <em>title</em>.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="examples_of_ucase">7.143.2. Examples of UCASE</h4>
+<h4 id="examples_of_ucase">7.144.2. Examples of UCASE</h4>
<div class="ulist">
<ul>
<li>
@@ -48384,7 +48790,7 @@ Hotel Oregon HOTEL OREGON hotel oregon
</div>
</div>
<div class="sect2">
-<h3 id="upper_function">7.144. UPPER Function</h3>
+<h3 id="upper_function">7.145. UPPER Function</h3>
<div class="paragraph">
<p>The UPPER function up-shifts alphanumeric characters. For
non-alphanumeric characters, UCASE returns the same character. UPPER can
@@ -48416,7 +48822,7 @@ See <a href="#character_value_expressions">Character
Value Expressions</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_upper">7.144.1. Examples of UPPER</h4>
+<h4 id="examples_of_upper">7.145.1. Examples of UPPER</h4>
<div class="ulist">
<ul>
<li>
@@ -48448,7 +48854,7 @@ see <a href="#upshift_function">UPSHIFT
Function</a>.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect3">
-<h4 id="upshift_function">7.144.2. UPSHIFT Function</h4>
+<h4 id="upshift_function">7.145.2. UPSHIFT Function</h4>
<div class="paragraph">
<p>The UPSHIFT function up-shifts alphanumeric characters. For
non-alphanumeric characters, UCASE returns the same character. UPSHIFT
@@ -48485,7 +48891,7 @@ characters to upshift. See
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_upshift">7.144.3. Examples of UPSHIFT</h4>
+<h4 id="examples_of_upshift">7.145.3. Examples of UPSHIFT</h4>
<div class="ulist">
<ul>
<li>
@@ -48548,7 +48954,7 @@ WHERE UPSHIFT(D1.deptname) =
UPSHIFT(D2.deptname);</code></pre>
</div>
</div>
<div class="sect2">
-<h3 id="rand_function">7.145. RAND Function</h3>
+<h3 id="rand_function">7.146. RAND Function</h3>
<div class="paragraph">
<p>The RAND function generates pseudo-random numbers that are uniformly
distributed
in the range between 0 and 2<sup>32</sup> (=4294967296),
@@ -48574,11 +48980,11 @@ So it can only be used in very few places, please do
not use it in a predicate.
</div>
</div>
<div class="sect3">
-<h4 id="rand_function_syntax">7.145.1. Syntax Descriptions of RAND
Function</h4>
+<h4 id="rand_function_syntax">7.146.1. Syntax Descriptions of RAND
Function</h4>
<div class="ulist">
<ul>
<li>
-<p><em>numeric-expression</em></p>
+<p><code><em>numeric-expression</em></code></p>
<div class="paragraph">
<p>is an SQL numeric value expression that specifies the value for the
argument of the RAND function. For more information, see <a
href="#numeric_value_expressions">Numeric Value Expressions</a>.</p>
</div>
@@ -48587,7 +48993,7 @@ So it can only be used in very few places, please do
not use it in a predicate.
</div>
</div>
<div class="sect3">
-<h4 id="rand_function_considerations">7.145.2. Considerations for RAND
Function</h4>
+<h4 id="rand_function_considerations">7.146.2. Considerations for RAND
Function</h4>
<div class="ulist">
<ul>
<li>
@@ -48597,19 +49003,21 @@ So it can only be used in very few places, please do
not use it in a predicate.
<li>
<p>the seed value should be an integer greater than or equal to 0, and cannot
be NULL.</p>
<div class="paragraph">
-<p>For example,</p>
+<p><strong>Example</strong></p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT
RAND(1-100) FROM DUAL;
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric
datatype. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:-99 Target
Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S16S64
Operation:RANGE_LOW. [2018-04-18 04:44:37]</code></pre>
+</div>
</div>
</li>
</ul>
</div>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT
RAND(1-100) FROM DUAL;
-
-*** ERROR[8432] A negative value cannot be converted to an unsigned numeric
datatype. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:-99 Target
Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S16S64
Operation:RANGE_LOW. [2018-04-18 04:44:37]
-
-
-SQL>SELECT RAND(NULL) FROM DUAL;
+<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT RAND(NULL)
FROM DUAL;
*** ERROR[4097] A NULL operand is not allowed in function (RANDOMNUM(NULL)).
[2018-04-18 04:44:48]</code></pre>
</div>
@@ -48636,7 +49044,7 @@ for each run of the program.</p>
<li>
<p>the RAND function will produce different series of numbers even it is
called consecutively within a query.</p>
<div class="paragraph">
-<p>For example,</p>
+<p><strong>Example</strong></p>
</div>
</li>
</ul>
@@ -48656,7 +49064,7 @@ for each run of the program.</p>
<li>
<p>To get desired numbers within a specified range, you can use a combination
of built-in functions, operators and clauses.</p>
<div class="paragraph">
-<p>For example,</p>
+<p><strong>Example</strong></p>
</div>
<div class="listingblock">
<div class="content">
@@ -48674,7 +49082,7 @@ for each run of the program.</p>
</div>
</div>
<div class="sect3">
-<h4 id="rand_function_example">7.145.3. Examples of RAND Function</h4>
+<h4 id="rand_function_example">7.146.3. Examples of RAND Function</h4>
<div class="ulist">
<ul>
<li>
@@ -48772,7 +49180,7 @@ C1 (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="user_function">7.146. USER Function</h3>
+<h3 id="user_function">7.147. USER Function</h3>
<div class="paragraph">
<p>The USER function returns either the database user name associated with
the specified user ID number or the database user name of the current
@@ -48803,7 +49211,7 @@ and the <a href="#current_user_function">CURRENT USER
Function</a>.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_user">7.146.1. Considerations for USER</h4>
+<h4 id="considerations_for_user">7.147.1. Considerations for USER</h4>
<div class="ulist">
<ul>
<li>
@@ -48816,7 +49224,7 @@ and the <a href="#current_user_function">CURRENT USER
Function</a>.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_user">7.146.2. Examples of USER</h4>
+<h4 id="examples_of_user">7.147.2. Examples of USER</h4>
<div class="ulist">
<ul>
<li>
@@ -48859,7 +49267,7 @@ DB ROOT
</div>
</div>
<div class="sect2">
-<h3 id="sys_guid_function">7.147. SYS_GUID Function</h3>
+<h3 id="sys_guid_function">7.148. SYS_GUID Function</h3>
<div class="paragraph">
<p>SYS_GUID returns a global unique identifier. The identifier is a 16-byte
value
tranformed into HEX format.
@@ -48877,7 +49285,7 @@ This function is for Oracle compatiblity.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_sys_guid">7.147.2. Examples of SYS_GUID</h4>
+<h4 id="examples_of_sys_guid">7.148.2. Examples of SYS_GUID</h4>
<div class="ulist">
<ul>
<li>
@@ -48900,7 +49308,7 @@ ID
</div>
</div>
<div class="sect2">
-<h3 id="uuid_function">7.148. UUID Function</h3>
+<h3 id="uuid_function">7.149. UUID Function</h3>
<div class="paragraph">
<p>Returns a Universal Unique Identifier (UUID) generated according to RFC
4122.
A UUID is designed as a number that is globally unique in space and time.
@@ -48933,7 +49341,7 @@ non-deterministic predicate evaluation.
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_uuid">7.148.2. Examples of UUID</h4>
+<h4 id="examples_of_uuid">7.149.2. Examples of UUID</h4>
<div class="ulist">
<ul>
<li>
@@ -48955,7 +49363,7 @@ ID
</div>
</div>
<div class="sect2">
-<h3 id="uuid_short_function">7.149. UUID_SHORT Function</h3>
+<h3 id="uuid_short_function">7.150. UUID_SHORT Function</h3>
<div class="paragraph">
<p>Returns a “short” universal identifier as a 64-bit unsigned integer.</p>
</div>
@@ -48985,7 +49393,7 @@ non-deterministic predicate evaluation.
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_uuid_short">7.149.2. Examples of UUID_SHORT</h4>
+<h4 id="examples_of_uuid_short">7.150.2. Examples of UUID_SHORT</h4>
<div class="ulist">
<ul>
<li>
@@ -49008,7 +49416,7 @@ ID
</div>
</div>
<div class="sect2">
-<h3 id="sleep_function">7.150. SLEEP Function</h3>
+<h3 id="sleep_function">7.151. SLEEP Function</h3>
<div class="paragraph">
<p>Sleeps (pauses) for the number of seconds given by the duration argument,
then returns 1.</p>
</div>
@@ -49018,7 +49426,7 @@ ID
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_sleep">7.150.1. Examples of SLEEP</h4>
+<h4 id="examples_of_sleep">7.151.1. Examples of SLEEP</h4>
<div class="ulist">
<ul>
<li>
@@ -49042,7 +49450,7 @@ ID
</div>
</div>
<div class="sect2">
-<h3 id="variance_function">7.151. VARIANCE Function</h3>
+<h3 id="variance_function">7.152. VARIANCE Function</h3>
<div class="paragraph">
<p>VARIANCE is an aggregate function that returns the statistical variance
of a set of numbers. VARIANCE is a Trafodion SQL extension.</p>
@@ -49088,7 +49496,7 @@ as <em>expression</em>. The one-column table derived
from the evaluation of
</ul>
</div>
<div class="sect3">
-<h4 id="considerations_for_variance">7.151.1. Considerations for VARIANCE</h4>
+<h4 id="considerations_for_variance">7.152.1. Considerations for VARIANCE</h4>
<div class="sect4">
<h5 id="definition_of_variance">Definition of VARIANCE</h5>
<div class="paragraph">
@@ -49182,7 +49590,7 @@ the computation of VARIANCE(x), then a numeric overflow
occurs.</p>
</div>
</div>
<div class="sect3">
-<h4 id="examples_of_variance">7.151.2. Examples of VARIANCE</h4>
+<h4 id="examples_of_variance">7.152.2. Examples of VARIANCE</h4>
<div class="ulist">
<ul>
<li>
@@ -49219,7 +49627,7 @@ VARIANCE_SALARY
</div>
</div>
<div class="sect2">
-<h3 id="week_function">7.152. WEEK Function</h3>
+<h3 id="week_function">7.153. WEEK Function</h3>
<div class="paragraph">
<p>The WEEK function converts a DATE or TIMESTAMP expression into an
INTEGER value in the range 1 through 54 that represents the
@@ -49251,7 +49659,7 @@ TIMESTAMP. See <a
href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_week">7.152.1. Examples of WEEK</h4>
+<h4 id="examples_of_week">7.153.1. Examples of WEEK</h4>
<div class="ulist">
<ul>
<li>
@@ -49275,7 +49683,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="year_function">7.153. YEAR Function</h3>
+<h3 id="year_function">7.154. YEAR Function</h3>
<div class="paragraph">
<p>The YEAR function converts a DATE or TIMESTAMP expression into an
INTEGER that represents the year.</p>
@@ -49300,7 +49708,7 @@ TIMESTAMP. See <a
href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_year">7.153.1. Examples of YEAR</h4>
+<h4 id="examples_of_year">7.154.1. Examples of YEAR</h4>
<div class="ulist">
<ul>
<li>
@@ -49324,7 +49732,7 @@ Start/Date Time/Shipped (EXPR)
</div>
</div>
<div class="sect2">
-<h3 id="unix_timestamp_function">7.154. UNIX_TIMESTAMP Function</h3>
+<h3 id="unix_timestamp_function">7.155. UNIX_TIMESTAMP Function</h3>
<div class="paragraph">
<p>If called with no argument, returns a Unix timestamp (seconds since
'1970-01-01 00:00:00' UTC)
as an unsigned integer. If UNIX_TIMESTAMP() is called with a date argument, it
returns the value
@@ -49350,7 +49758,7 @@ TIMESTAMP. See <a
href="#datetime_value_expressions">Datetime Value Expressions<
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_unix_timestamp">7.154.1. Examples of UNIX_TIMESTAMP</h4>
+<h4 id="examples_of_unix_timestamp">7.155.1. Examples of UNIX_TIMESTAMP</h4>
<div class="ulist">
<ul>
<li>
@@ -49388,7 +49796,7 @@ TIMESTAMP. See <a
href="#datetime_value_expressions">Datetime Value Expressions<
</div>
</div>
<div class="sect2">
-<h3 id="zeroifnull_function">7.155. ZEROIFNULL Function</h3>
+<h3 id="zeroifnull_function">7.156. ZEROIFNULL Function</h3>
<div class="paragraph">
<p>The ZEROIFNULL function returns a value of zero if the expression if
NULL. Otherwise, it returns the value of the expression.</p>
@@ -49409,7 +49817,7 @@ NULL. Otherwise, it returns the value of the
expression.</p>
</ul>
</div>
<div class="sect3">
-<h4 id="examples_of_zeroifnull">7.155.1. Examples of ZEROIFNULL</h4>
+<h4 id="examples_of_zeroifnull">7.156.1. Examples of ZEROIFNULL</h4>
<div class="ulist">
<ul>
<li>
@@ -53980,7 +54388,7 @@ or 256 bytes of UTF8 text, whichever is less.</p></td>
</div>
<div id="footer">
<div id="footer-text">
-Version 2.4.0<br>
+Version <br>
Last updated 2018-12-15 13:12:46 +08:00
</div>
</div>
