Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

ASCII(A) ASCII(Z) ASCII(A) ASCII(Z) ASCII(ABC)

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>