Re: tab ascii value

[Bryan S]

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 --------- you me us     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:[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