Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 6 of 166
ascii::=
ascii
ASCII
returns the decimal representation in the database character set of the first character of char.
char can be of datatype CHAR
, VARCHAR2
, NCHAR
, or NVARCHAR2
. The value returned is of datatype NUMBER
. If your database character set is 7-bit ASCII, this function returns an ASCII value. If your database character set is EBCDIC Code, this function returns an EBCDIC value. There is no corresponding EBCDIC character function.
Note:
This function does not support |
The following example returns the ASCII decimal equivalent of the letter Q:
SELECT ASCII('Q') FROM DUAL; ASCII('Q') ---------- 81
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|