Re: tab ascii value

Thu, 30 Aug 2001 03:04:49 -0700

Title: RE: tab ascii value
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;

 

----- Original Message -----
From: Bryan S
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;
 
'YOU'||CH
---------
you
me
us
 
 
HTH,
Bryan
 
----- Original Message -----
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

Reply via email to