http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FConversion_Functions%2FTO_NUMBER
Oracle PL/SQL Tutorial/Conversion Functions/TO NUMBER - История изменений
2026-04-03T18:45:44Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Conversion_Functions/TO_NUMBER&diff=3999&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<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_Tutorial/Conversion_Functions/TO_NUMBER&diff=4000&oldid=prev
Admin: 1 версия
2010-05-26T10:08:18Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Converts the string -$12,345.67 to a number, passing the format string $99,999.99 to TO_NUMBER()==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> SELECT TO_NUMBER("-$12,345.67", "$99,999.99") FROM dual;<br />
TO_NUMBER("-$12,345.67","$99,999.99")<br />
-------------------------------------<br />
-12345.67<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== Convert the string 97.13 to a number using TO_NUMBER() and then adds 25.5 to that number==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> SELECT TO_NUMBER("97.13") + 25.5 FROM dual;<br />
TO_NUMBER("97.13")+25.5<br />
-----------------------<br />
122.63<br />
SQL></source><br />
<br />
<br />
<br />
== to_number("123")==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> select 123<br />
2 , to_char(123)<br />
3 , to_char(123,"$09999.99")<br />
4 , to_number("123")<br />
5 from dual;<br />
123 TO_ TO_CHAR(12 TO_NUMBER("123")<br />
---------- --- ---------- ----------------<br />
123 123 $00123.00 123<br />
SQL></source><br />
<br />
<br />
<br />
== TO_NUMBER(x [, format]) converts x to a number.==<br />
<br />
<p>The TO_NUMBER function converts a character string of type CHAR or VARCHAR2 into a number.</p><br />
<p>The Syntax for the TO_NUMBER Function</p><br />
<p>TO_NUMBER(character_string, format, NLS_Params)</p><br />
<p>After the format mask are several possible NLS parameters:</p><br />
<OL><LI>NLS_NUMERIC_CHARACTERS -- Specifies characters to use for group separators and the decimal point.</LI><LI>NLS_CURRENCY -- Specifies the local currency.</LI><LI>NLS_ISO_CURRENCY -- Character(s) to represent the ISO currency symbol.</LI></OL><br />
<p>You can provide an optional format string to indicate the format of x.</p><br />
Parameter<br />
Format Examples<br />
9<br />
999<br />
0<br />
0999 9990<br />
.<br />
999.99<br />
,<br />
9,999<br />
$<br />
$999<br />
B<br />
B9.99<br />
C<br />
C999<br />
D<br />
9D99<br />
EEEE<br />
9.99EEEE<br />
FM<br />
FM90.9<br />
G<br />
9G999<br />
L<br />
L999<br />
MI<br />
999MI<br />
PR<br />
999PR<br />
RN rn<br />
RN rn<br />
S<br />
S999 999S<br />
TM<br />
TM<br />
U<br />
U999<br />
V<br />
99V99<br />
X<br />
XXXX<br />
<p>The following example converts the string 97.13 to a number using TO_NUMBER():</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> SELECT TO_NUMBER("97.13") FROM dual;<br />
TO_NUMBER("97.13")<br />
------------------<br />
97.13<br />
SQL></source></div>
Admin