declare
i int;
j int;
begin
for i in 65..90 loop --得到字母A-Z,如果只需要Q后面的,把65换为82
insert into test (mapcode) values (chr(i));
end loop;
for i in 65..90 loop
for j in 65..90 loop
insert into test (mapcode) values (chr(i)||chr(j));
end loop;
end loop;
end;
/
commit;