> -----Original Message-----
> From: Tatireddy, Shrinivas (MED, Keane)
> [mailto:[EMAIL PROTECTED]]
>
> how to find out the ascii value of tab, new line
>
> for new line it is 10
> for tab it is 9
>
> but how to get from the following statement.
>
> select ascii(??????) from dual;
I don't remember if this has been answered already, but read the documentation on the DUMP and CHR functions.
SQL> select dump ('A') from dual ;
DUMP('A')
----------------
Typ=96 Len=1: 65
SQL> select chr (65) from dual ;
C
-
A
