http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FPL_SQL%2FNumber_to_Char
Oracle PL/SQL/PL SQL/Number to Char - История изменений
2026-05-25T19:34:40Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/PL_SQL/Number_to_Char&diff=1941&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/PL_SQL/Number_to_Char&diff=1942&oldid=prev
Admin: 1 версия
2010-05-26T09:59:40Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Converting a character formatted as currency to an integer value==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> -- Converting a character formatted as currency to an integer value.<br />
SQL> DECLARE<br />
2 myString VARCHAR2(20) := "$123,456.78";<br />
3 myNumber NUMBER ;<br />
4 BEGIN<br />
5 myNumber := TO_Number(myString,"$999,999,999.99");<br />
6 DBMS_OUTPUT.PUT_LINE("The converted number is: " || myString);<br />
7 DBMS_OUTPUT.PUT_LINE("Your commission at 6% is: " || (myNumber*.06));<br />
8 END;<br />
9 /<br />
The converted number is: $123,456.78<br />
Your commission at 6% is: 7407.4068<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Converting Numbers to Characters Formatted as a Numeric String==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> DECLARE<br />
2 v_Convert_Number NUMBER := 90210;<br />
3 v_Hold_Char VARCHAR2(21) ;<br />
4 BEGIN<br />
5 v_Hold_Char := TO_CHAR(v_Convert_Number,"0000000000");<br />
6 DBMS_OUTPUT.PUT_LINE("The employee ID is: " || v_Hold_Char);<br />
7 END;<br />
8 /<br />
The employee ID is: 0000090210<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL><br />
SQL> --<br />
</source><br />
<br />
<br />
<br />
<br />
==Expressing Your Work in Scientific Notation==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> DECLARE<br />
2 v_Convert_Number NUMBER := 90210;<br />
3 v_Hold_Char VARCHAR2(21) ;<br />
4 BEGIN<br />
5 v_Hold_Char := TO_CHAR(v_Convert_Number,"9.99EEEE");<br />
6 DBMS_OUTPUT.PUT_LINE("The Scientific Notation is: " || v_Hold_Char);<br />
7 END;<br />
8 /<br />
The Scientific Notation is: 9.02E+04<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL><br />
SQL> --<br />
</source><br />
<br />
<br />
<br />
<br />
==Illegal conversion between character and number==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> DECLARE<br />
2 v_TempVar NUMBER;<br />
3 BEGIN<br />
4 v_TempVar := "xyz";<br />
5 END;<br />
6 /<br />
DECLARE<br />
*<br />
ERROR at line 1:<br />
ORA-06502: PL/SQL: numeric or value error: character to number conversion error<br />
ORA-06512: at line 4<br />
<br />
SQL><br />
SQL><br />
</source></div>
Admin