Re: tab ascii value

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Thu, 30 Aug 2001 03:04:49 -0700
Message-ID: <F001.0037C990.20010830022122@fatcity.com>

This script prints the ascii table
whole.
May be usefull.
Bunyamin

set serveroutput on size 10240
declare

i number;
j number;
k number;

begin
for i in 2..15 loop

  for j in 1..16 loop
    k:=i*16+j;
    dbms_output.put((to_char(k,'000'))||':'||chr(k)||' ');
    if k mod 8 = 0 then
    dbms_output.put_line('');
  end if;
  end loop;

end loop;
end;
 
<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: Bryan S

  To: <A href="mailto:ORACLE-L_at_fatcity.com"   title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L   Sent: Thursday, August 30, 2001 5:25
  AM
  Subject: 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;
 

  <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 Thu Aug 30 2001 - 05:04:49 CDT