в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:11:34Z

1 версия

Новая страница

== ASCII(0), ASCII(9)==



<source lang="sql">
SQL>
SQL> select ASCII(0), ASCII(9) FROM dual;
ASCII(0) ASCII(9)
---------- ----------
48 57</source>

== ASCII("A") ASCII("Z") ASCII("A") ASCII("Z") ASCII("ABC")==



<source lang="sql">
SQL>
SQL>
SQL> select ascii("a"), ascii("z")
2 , ascii("A"), ascii("Z")
3 , ascii("ABC"), chr(77)
4 from dual;
ASCII("A") ASCII("Z") ASCII("A") ASCII("Z") ASCII("ABC") C
---------- ---------- ---------- ---------- ------------ -
97 122 65 90 65 M
SQL></source>

== Ascii gives the ASCII value of the first character of a string==

The general format for this function is: ASCII(string)



<source lang="sql">
SQL>
SQL> SELECT ASCII("first") FROM dual;
ASCII("FIRST")
--------------
102</source>

== ASCII(x) gets the ASCII value of the character x==

CHR() and ASCII() have the opposite effect.
The following example gets the ASCII value of a, A, z, Z, 0, and 9 using ASCII().



<source lang="sql">
SQL> SELECT ASCII("a"), ASCII("A"), ASCII("z"), ASCII("Z") from dual;
ASCII("A") ASCII("A") ASCII("Z") ASCII("Z")
---------- ---------- ---------- ----------
97 65 122 90
SQL></source>

== select ascii("a"), ascii("z"),ascii("A"), ascii("Z"),ascii("ABC"), chr(77)==



<source lang="sql">
SQL>
SQL>
SQL> select ascii("a"), ascii("z"),ascii("A"), ascii("Z"),ascii("ABC"), chr(77)
2 from dual;
ASCII("A") ASCII("Z") ASCII("A") ASCII("Z") ASCII("ABC") C
---------- ---------- ---------- ---------- ------------ -
97 122 65 90 65 M
SQL></source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/Character String Functions/ASCII - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия