RE: tab ascii value

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Tue, 28 Aug 2001 08:15:05 -0700
Message-ID: <F001.0037996D.20010828071119@fatcity.com>

John,

Here's a message I got from Dennis Heisler off this list last week. The method works quite well:

David,

There are a number of different ways to do it. One method I use is to define the codes in the package header
  ie: FONT_COURIER10 varchar2(15) := chr(27) || '(s0p10h12vsb3T'

Then, in the package body, when I want to print a special code I either use utl_file.put() or utl_file.put_line(FONT_COURIER10 || 'Text Goes Here').

Dennis

Good Luck.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                          
                    Hallas John                                                        
                          
                    <John.Hallas_at_btce       To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>  
                    llnet.net>              cc:                                        
                          
                    Sent by:                Subject:     RE: tab ascii value           
                          
                    root_at_fatcity.com                                                   
                          
                                                                                       
                          
                                                                                       
                          
                    08/28/2001 08:05                                                   
                          
                    AM                                                                 
                          
                    Please respond to                                                  
                          
                    ORACLE-L                                                           
                          
                                                                                       
                          
                                                                                       
                          

Srinivas,
I have managed the following PL/SQL but I have not worked out how to show the tab and CR return characters etc. Perhaps someone else can help

John
SCRIPT start xxxxxxxxxx
declare
V_chr varchar2(3);
ctr number;
begin

        for ctr in  1..255 loop
        select chr(ctr) into V_chr from dual;


--      dbms_output.put_line(V_chr);

        dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');

end loop;
end;

SCRIPT ends XXXXXXXXXXXXXXXX
Chr value 1 =
Chr value 2 =
Chr value 3 =
Chr value 4 =
Chr value 5 =
Chr value 6 =
Chr value 7 =

Chr value 8 =
Chr value 9 =
Chr value 10 =

Chr value 11 =

Chr value 12 =

Chr value 13 =
Chr value 14 =
Chr value 15 =
Chr value 16 =
Chr value 17 =
Chr value 18 =
Chr value 19 =
Chr value 20 =
Chr value 21 =
Chr value 22 =
Chr value 23 =
Chr value 24 =
Chr value 25 =
Chr value 26 =
Chr value 27 =

hr value 28 =

Chr value 29 =
Chr value 30 =
Chr value 31 =
Chr value 32 =
Chr value 33 = !
Chr value 34 = "
Chr value 35 = #
Chr value 36 = $
Chr value 37 = %
Chr value 38 = &
Chr value 39 = '
Chr value 40 = (
Chr value 41 = )
Chr value 42 = *
Chr value 43 = +
Chr value 44 = ,
Chr value 45 = -
Chr value 46 = .
Chr value 47 = /
Chr value 48 = 0
Chr value 49 = 1
Chr value 50 = 2
Chr value 51 = 3
Chr value 52 = 4
Chr value 53 = 5
Chr value 54 = 6
Chr value 55 = 7
Chr value 56 = 8
Chr value 57 = 9
Chr value 58 = :
Chr value 59 = ;
Chr value 60 = <
Chr value 61 = =
Chr value 62 = >
Chr value 63 = ?
Chr value 64 = @
Chr value 65 = A
Chr value 66 = B
Chr value 67 = C
Chr value 68 = D
Chr value 69 = E
Chr value 70 = F
Chr value 71 = G
Chr value 72 = H
Chr value 73 = I
Chr value 74 = J
Chr value 75 = K
Chr value 76 = L
Chr value 77 = M
Chr value 78 = N
Chr value 79 = O
Chr value 80 = P
Chr value 81 = Q
Chr value 82 = R
Chr value 83 = S
Chr value 84 = T
Chr value 85 = U
Chr value 86 = V
Chr value 87 = W
Chr value 88 = X
Chr value 89 = Y
Chr value 90 = Z
Chr value 91 = [
Chr value 92 = \
Chr value 93 = ]
Chr value 94 = ^
Chr value 95 = _
Chr value 96 = `
Chr value 97 = a
Chr value 98 = b
Chr value 99 = c
Chr value 100 = d
Chr value 101 = e
Chr value 102 = f
Chr value 103 = g
Chr value 104 = h
Chr value 105 = i
Chr value 106 = j
Chr value 107 = k
Chr value 108 = l
Chr value 109 = m
Chr value 110 = n
Chr value 111 = o
Chr value 112 = p
Chr value 113 = q
Chr value 114 = r
Chr value 115 = s
Chr value 116 = t
Chr value 117 = u
Chr value 118 = v
Chr value 119 = w
Chr value 120 = x
Chr value 121 = y
Chr value 122 = z
Chr value 123 = {
Chr value 124 = |
Chr value 125 = }
Chr value 126 = ~
Chr value 127 =
Chr value 128 = ?
Chr value 129 = ?
Chr value 130 = ?
Chr value 131 = ?
Chr value 132 = ?
Chr value 133 = ?
Chr value 134 = ?
Chr value 135 = ?
Chr value 136 = ?
Chr value 137 = ?
Chr value 138 = ?
Chr value 139 = ?
Chr value 140 = ?
Chr value 141 = ?
Chr value 142 = ?
Chr value 143 = ?
Chr value 144 = ?
Chr value 145 = ?
Chr value 146 = ?
Chr value 147 = ?
Chr value 148 = ?
Chr value 149 = ?
Chr value 150 = ?
Chr value 151 = ?
Chr value 152 = ?
Chr value 153 = ?
Chr value 154 = ?
Chr value 155 = ?
Chr value 156 = ?
Chr value 157 = ?
Chr value 158 = ?
Chr value 159 = ?
Chr value 160 =
Chr value 161 = !
Chr value 162 = ?
Chr value 163 = #
Chr value 164 = ?
Chr value 165 = Y
Chr value 166 = |
Chr value 167 = ?
Chr value 168 = ?
Chr value 169 = ?
Chr value 170 = ?
Chr value 171 = <
Chr value 172 = ?
Chr value 173 = -
Chr value 174 = ?
Chr value 175 = ?
Chr value 176 = ?
Chr value 177 = ?
Chr value 178 = ?
Chr value 179 = ?
Chr value 180 = '
Chr value 181 = ?
Chr value 182 = ?
Chr value 183 = ?
Chr value 184 = ?
Chr value 185 = ?
Chr value 186 = ?
Chr value 187 = >
Chr value 188 = ?
Chr value 189 = ?
Chr value 190 = ?
Chr value 191 = ?
Chr value 192 = A
Chr value 193 = A
Chr value 194 = A
Chr value 195 = ?
Chr value 196 = A
Chr value 197 = ?
Chr value 198 = ?
Chr value 199 = C
Chr value 200 = E
Chr value 201 = E
Chr value 202 = E
Chr value 203 = E
Chr value 204 = I
Chr value 205 = I
Chr value 206 = I
Chr value 207 = I
Chr value 208 = ?
Chr value 209 = ?
Chr value 210 = O
Chr value 211 = O
Chr value 212 = O
Chr value 213 = ?
Chr value 214 = O
Chr value 215 = ?
Chr value 216 = ?
Chr value 217 = U
Chr value 218 = U
Chr value 219 = U
Chr value 220 = U
Chr value 221 = Y
Chr value 222 = ?

Chr value 223 = ?
Chr value 224 = a
declare
V_chr varchar2(3);
ctr number;
begin

        for ctr in  1..255 loop
        select chr(ctr) into V_chr from dual;


--      dbms_output.put_line(V_chr);

        dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');

end loop;
end;

Chr value 225 = a
Chr value 226 = a
Chr value 227 = ?
Chr value 228 = a
Chr value 229 = ?
Chr value 230 = ?
Chr value 231 = c
Chr value 232 = e
Chr value 233 = e
Chr value 234 = e
Chr value 235 = e
Chr value 236 = i
Chr value 237 = i
Chr value 238 = i
Chr value 239 = i
Chr value 240 = ?
Chr value 241 = ?
Chr value 242 = o
Chr value 243 = o
Chr value 244 = o
Chr value 245 = ?
Chr value 246 = o
Chr value 247 = ?
Chr value 248 = ?
Chr value 249 = u
Chr value 250 = u
Chr value 251 = u
Chr value 252 = u
Chr value 253 = y
Chr value 254 = ?
Chr value 255 = y

PL/SQL procedure successfully completed.

-----Original Message-----

[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: 25 August 01 09:20
To: Multiple recipients of list ORACLE-L

Hi lists

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;

srinivas

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane)   INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium.

---

Srinivas,
I have managed the following PL/SQL but I have not worked out how to show the tab and CR return characters etc. Perhaps someone else can help

John
SCRIPT start xxxxxxxxxx
declare
V_chr varchar2(3);
ctr number;
begin

        for ctr in  1..255 loop
        select chr(ctr) into V_chr from dual;


--      dbms_output.put_line(V_chr);

        dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');

end loop;
end;

SCRIPT ends XXXXXXXXXXXXXXXX
Chr value 1 =
Chr value 2 =
Chr value 3 =
Chr value 4 =
Chr value 5 =
Chr value 6 =
Chr value 7 =

Chr value 8 =
Chr value 9 =
Chr value 10 =

Chr value 11 =

Chr value 12 =

Chr value 13 =
Chr value 14 =
Chr value 15 =
Chr value 16 =
Chr value 17 =
Chr value 18 =
Chr value 19 =
Chr value 20 =
Chr value 21 =
Chr value 22 =
Chr value 23 =
Chr value 24 =
Chr value 25 =
Chr value 26 =
Chr value 27 =

hr value 28 =

Chr value 29 =
Chr value 30 =
Chr value 31 =
Chr value 32 =
Chr value 33 = !
Chr value 34 = "
Chr value 35 = #
Chr value 36 = $
Chr value 37 = %
Chr value 38 = &
Chr value 39 = '
Chr value 40 = (
Chr value 41 = )
Chr value 42 = *
Chr value 43 = +
Chr value 44 = ,
Chr value 45 = -
Chr value 46 = .
Chr value 47 = /
Chr value 48 = 0
Chr value 49 = 1
Chr value 50 = 2
Chr value 51 = 3
Chr value 52 = 4
Chr value 53 = 5
Chr value 54 = 6
Chr value 55 = 7
Chr value 56 = 8
Chr value 57 = 9
Chr value 58 = :
Chr value 59 = ;
Chr value 60 = <
Chr value 61 = =
Chr value 62 = >
Chr value 63 = ?
Chr value 64 = @
Chr value 65 = A
Chr value 66 = B
Chr value 67 = C
Chr value 68 = D
Chr value 69 = E
Chr value 70 = F
Chr value 71 = G
Chr value 72 = H
Chr value 73 = I
Chr value 74 = J
Chr value 75 = K
Chr value 76 = L
Chr value 77 = M
Chr value 78 = N
Chr value 79 = O
Chr value 80 = P
Chr value 81 = Q
Chr value 82 = R
Chr value 83 = S
Chr value 84 = T
Chr value 85 = U
Chr value 86 = V
Chr value 87 = W
Chr value 88 = X
Chr value 89 = Y
Chr value 90 = Z
Chr value 91 = [
Chr value 92 = \
Chr value 93 = ]
Chr value 94 = ^
Chr value 95 = _
Chr value 96 = `
Chr value 97 = a
Chr value 98 = b
Chr value 99 = c
Chr value 100 = d
Chr value 101 = e
Chr value 102 = f
Chr value 103 = g
Chr value 104 = h
Chr value 105 = i
Chr value 106 = j
Chr value 107 = k
Chr value 108 = l
Chr value 109 = m
Chr value 110 = n
Chr value 111 = o
Chr value 112 = p
Chr value 113 = q
Chr value 114 = r
Chr value 115 = s
Chr value 116 = t
Chr value 117 = u
Chr value 118 = v
Chr value 119 = w
Chr value 120 = x
Chr value 121 = y
Chr value 122 = z
Chr value 123 = {
Chr value 124 = |
Chr value 125 = }
Chr value 126 = ~
Chr value 127 =
Chr value 128 = ?
Chr value 129 = ?
Chr value 130 = ?
Chr value 131 = ?
Chr value 132 = ?
Chr value 133 = ?
Chr value 134 = ?
Chr value 135 = ?
Chr value 136 = ?
Chr value 137 = ?
Chr value 138 = ?
Chr value 139 = ?
Chr value 140 = ?
Chr value 141 = ?
Chr value 142 = ?
Chr value 143 = ?
Chr value 144 = ?
Chr value 145 = ?
Chr value 146 = ?
Chr value 147 = ?
Chr value 148 = ?
Chr value 149 = ?
Chr value 150 = ?
Chr value 151 = ?
Chr value 152 = ?
Chr value 153 = ?
Chr value 154 = ?
Chr value 155 = ?
Chr value 156 = ?
Chr value 157 = ?
Chr value 158 = ?
Chr value 159 = ?
Chr value 160 =
Chr value 161 = !
Chr value 162 = ?
Chr value 163 = #
Chr value 164 = ?
Chr value 165 = Y
Chr value 166 = |
Chr value 167 = ?
Chr value 168 = ?
Chr value 169 = ?
Chr value 170 = ?
Chr value 171 = <
Chr value 172 = ?
Chr value 173 = -
Chr value 174 = ?
Chr value 175 = ?
Chr value 176 = ?
Chr value 177 = ?
Chr value 178 = ?
Chr value 179 = ?
Chr value 180 = '
Chr value 181 = ?
Chr value 182 = ?
Chr value 183 = ?
Chr value 184 = ?
Chr value 185 = ?
Chr value 186 = ?
Chr value 187 = >
Chr value 188 = ?
Chr value 189 = ?
Chr value 190 = ?
Chr value 191 = ?
Chr value 192 = A
Chr value 193 = A
Chr value 194 = A
Chr value 195 = ?
Chr value 196 = A
Chr value 197 = ?
Chr value 198 = ?
Chr value 199 = C
Chr value 200 = E
Chr value 201 = E
Chr value 202 = E
Chr value 203 = E
Chr value 204 = I
Chr value 205 = I
Chr value 206 = I
Chr value 207 = I
Chr value 208 = ?
Chr value 209 = ?
Chr value 210 = O
Chr value 211 = O
Chr value 212 = O
Chr value 213 = ?
Chr value 214 = O
Chr value 215 = ?
Chr value 216 = ?
Chr value 217 = U
Chr value 218 = U
Chr value 219 = U
Chr value 220 = U
Chr value 221 = Y
Chr value 222 = ?

Chr value 223 = ?
Chr value 224 = a
declare
V_chr varchar2(3);
ctr number;
begin

        for ctr in  1..255 loop
        select chr(ctr) into V_chr from dual;


--      dbms_output.put_line(V_chr);

        dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');

end loop;
end;

Chr value 225 = a
Chr value 226 = a
Chr value 227 = ?
Chr value 228 = a
Chr value 229 = ?
Chr value 230 = ?
Chr value 231 = c
Chr value 232 = e
Chr value 233 = e
Chr value 234 = e
Chr value 235 = e
Chr value 236 = i
Chr value 237 = i
Chr value 238 = i
Chr value 239 = i
Chr value 240 = ?
Chr value 241 = ?
Chr value 242 = o
Chr value 243 = o
Chr value 244 = o
Chr value 245 = ?
Chr value 246 = o
Chr value 247 = ?
Chr value 248 = ?
Chr value 249 = u
Chr value 250 = u
Chr value 251 = u
Chr value 252 = u
Chr value 253 = y
Chr value 254 = ?
Chr value 255 = y

PL/SQL procedure successfully completed.

-----Original Message-----

[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: 25 August 01 09:20
To: Multiple recipients of list ORACLE-L

Hi lists

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;

srinivas

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane)   INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium.

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 28 2001 - 10:15:05 CDT