From bryan.indy@home.com Wed, 29 Aug 2001 18:10:18 -0700 From: "Bryan S" Date: Wed, 29 Aug 2001 18:10:18 -0700 Subject: Re: tab ascii value Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: tab ascii value I'm not sure about the tab.  I did the following ('tab' is between the ' '):   SQL> select dump(' ') from dual;   DUMP('')----------------Typ=96 Len=1: 32   SQL> select chr(32) from dual;   C- It looks like a tab, but since it is a nonprinting character, it's hard to tell.   I'm pretty sure new line is 13 ( appears as ^M line ending char when viewed in vi).  I looked it up once online, and I did the following:   SQL> select chr(013) from dual;   C-       SQL>  select 'you' || chr(13) || 'me' || chr(13) || 'us'  2  from dual;   'YOU'||CH---------youmeus     HTH, Bryan  
----- Original Message -----
From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 28, 2001 2:21 PM Subject: RE: tab ascii value > -----Original Message----- > From: Tatireddy, Shrinivas (MED, Keane) > [mailto:Shrinivas.Tatireddy@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