Skip to end of metadata
Go to start of metadata

To show the ASCII table of the database in current charset:

SQL> set serveroutput on
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,'XX')||(to_char(k,'000'))||':'||chr(k)||' ');
if k  mod  8 =  0 then
dbms_output.put_line();
end if;
end loop;
end loop;
end;

 

Example from WE8ISO8859P156:

anonymous block completed
21 033:!  22 034:"  23 035:#  24 036:$  25 037:%  26 038:&  27 039:'  28 040:( 
29 041:)  2A 042:*  2B 043:+  2C 044:,  2D 045:-  2E 046:.  2F 047:/  30 048:0 
31 049:1  32 050:2  33 051:3  34 052:4  35 053:5  36 054:6  37 055:7  38 056:8 
39 057:9  3A 058::  3B 059:;  3C 060:<  3D 061:=  3E 062:>  3F 063:?  40 064:@ 
41 065:A  42 066:B  43 067:C  44 068:D  45 069:E  46 070:F  47 071:G  48 072:H 
49 073:I  4A 074:J  4B 075:K  4C 076:L  4D 077:M  4E 078:N  4F 079:O  50 080:P 
51 081:Q  52 082:R  53 083:S  54 084:T  55 085:U  56 086:V  57 087:W  58 088:X 
59 089:Y  5A 090:Z  5B 091:[  5C 092:\  5D 093:]  5E 094:^  5F 095:_  60 096:` 
61 097:a  62 098:b  63 099:c  64 100:d  65 101:e  66 102:f  67 103:g  68 104:h 
69 105:i  6A 106:j  6B 107:k  6C 108:l  6D 109:m  6E 110:n  6F 111:o  70 112:p 
71 113:q  72 114:r  73 115:s  74 116:t  75 117:u  76 118:v  77 119:w  78 120:x 
79 121:y  7A 122:z  7B 123:{  7C 124:|  7D 125:}  7E 126:~  7F 127:  80 128:€ 
81 129:  82 130:‚  83 131:ƒ  84 132:„  85 133:…  86 134:†  87 135:‡  88 136:ˆ 
89 137:‰  8A 138:Š  8B 139:‹  8C 140:Œ  8D 141:  8E 142:Ž  8F 143:  90 144: 
91 145:‘  92 146:’  93 147:“  94 148:”  95 149:•  96 150:–  97 151:—  98 152:˜ 
99 153:™  9A 154:š  9B 155:›  9C 156:œ  9D 157:  9E 158:ž  9F 159:Ÿ  A0 160:  
A1 161:¡  A2 162:¢  A3 163:£  A4 164:€  A5 165:¥  A6 166:Š  A7 167:§  A8 168:š 
A9 169:©  AA 170:ª  AB 171:«  AC 172:¬  AD 173:­  AE 174:®  AF 175:¯  B0 176:° 
B1 177:±  B2 178:²  B3 179:³  B4 180:Ž  B5 181:µ  B6 182:¶  B7 183:·  B8 184:ž 
B9 185:¹  BA 186:º  BB 187:»  BC 188:Œ  BD 189:œ  BE 190:Ÿ  BF 191:¿  C0 192:À 
C1 193:Á  C2 194:Â  C3 195:Ã  C4 196:Ä  C5 197:Å  C6 198:Æ  C7 199:Ç  C8 200:È 
C9 201:É  CA 202:Ê  CB 203:Ë  CC 204:Ì  CD 205:Í  CE 206:Î  CF 207:Ï  D0 208:Ð 
D1 209:Ñ  D2 210:Ò  D3 211:Ó  D4 212:Ô  D5 213:Õ  D6 214:Ö  D7 215:×  D8 216:Ø 
D9 217:Ù  DA 218:Ú  DB 219:Û  DC 220:Ü  DD 221:Ý  DE 222:Þ  DF 223:ß  E0 224:à 
E1 225:á  E2 226:â  E3 227:ã  E4 228:ä  E5 229:å  E6 230:æ  E7 231:ç  E8 232:è 
E9 233:é  EA 234:ê  EB 235:ë  EC 236:ì  ED 237:í  EE 238:î  EF 239:ï  F0 240:ð 
F1 241:ñ  F2 242:ò  F3 243:ó  F4 244:ô  F5 245:õ  F6 246:ö  F7 247:÷  F8 248:ø 
F9 249:ù  FA 250:ú  FB 251:û  FC 252:ü  FD 253:ý  FE 254:þ  FF 255:ÿ ### 256: