Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Select ascii(a), ascii(z),ascii(A), ascii(Z),ascii(ABC), chr(77)

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>