RE: tab ascii value

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 28 Aug 2001 11:02:01 -0700
Message-ID: <F001.0037A11C.20010828112140@fatcity.com>

> -----Original Message-----
> From: Tatireddy, Shrinivas (MED, Keane)
> [mailto:Shrinivas.Tatireddy_at_med.ge.com]
>
> 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 Received on Tue Aug 28 2001 - 13:02:01 CDT