Mne nado dorabotati script SQL, catorii vivodil bi mne vse ASCII codi vseh simvolov catorii Oracle podderjivaiet...

Dlia nacialo I sozdal tablitu 'coduri_ascii' v cotoroi I hraniu simvoli Oracle v odnom pole i v drugom sootvestvuiscii emu cod ASCII. The script:

prompt Tabela de coduri ASCII
rem Crearea unui fisier spool...
spool d:\a.txt

/*****************************/
rem Distugerea tabelei coduri_ascii
drop table coduri_ascii
/*****************************/

rem Crearea unei tabele, care va pastra codurile ASCII
create table coduri_ascii
(
symbol varchar2(4),
cod varchar2(4)
);
commit;

rem Procedura de inscriere a datelor in tabela 'coduri_ascii'
declare
i number := 0;
begin
while(i<10) loop
insert into coduri_ascii(symbol, cod) values(to_char(i), to_char(ascii(to_char(i))));
i:=i+1;
end loop;
end;
/
commit;
exit;

Cac You videte I zapolniau tablitu tiframi s '0' do '9' i ih cod ASCII. Please pomogite, cac mne zapolniti tablitu drughimi simvolami podderjivaiusie Oracle... naprimer vseh bucv 'a' ; 'A' ; '#' ; '%' etc...

Во первых Trampler, Thanks.

Я закончил Script и у меня получилось:
prompt Tabela de coduri ASCII
rem Crearea unui fisier spool...
spool d:\a.txt

/*****************************/
rem Golirea tabelei coduri_ascii
delete coduri_ascii;
/*****************************/

rem Procedura de inscriere a datelor in tabela 'coduri_ascii'
declare
i number;
begin
for i in 0..255
loop
insert into coduri_ascii(symbol, cod) values(chr(i), to_char(i));
end loop;
end;
/
commit;

/***************************/
rem Formarea fisierului spool cu codurile ascii
set feedback off heading off
spool d:\coduri_ascii.txt

set termout off trimspool on
select * from coduri_ascii;

rem fin de script
exit;

Когда Я открываю фаил "coduri_ascii.txt" первые 32-е записи, мне не понятны. Please объясните, почему имено так а не подругому...

Содержание фаила coduri_ascii.txt:

0
1
2
3
4
5
6
7
8
9
10

11
12


13
14
15
16
17
18
19
20
21
22
23
24
25

26
27
28
29
30
31
32
! 33
" 34
# 35
$ 36
% 37
& 38

etc...