Re: tab ascii value

From: Bryan S <bryan.indy_at_home.com>
Date: Wed, 29 Aug 2001 18:10:18 -0700
Message-ID: <F001.0037C602.20010829182528@fatcity.com>

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;
 

<FONT face=Arial
size=2>'YOU'||CH---------youmeus
 
 

HTH,
Bryan
 

<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A href="mailto:Jacques.Kilchoer_at_quest.com" title=Jacques.Kilchoer_at_quest.com>Jacques Kilchoer To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>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) > [<A   href="mailto:Shrinivas.Tatireddy_at_med.ge.com">mailto:Shrinivas.Tatireddy_at_med.ge.com]   > > how to find out the ascii
  value of tab, new line > <FONT
  size=2>> for new line it is 10 > for tab it is   9 > > but how to get
  from the following statement. > <FONT   size=2>> 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 Wed Aug 29 2001 - 20:10:18 CDT