|
本帖最后由 solomon_007 于 2015-10-15 22:46 编辑
答案发布不上来呀 656
create table t (rowno int,colno int,val int);
SQL>
SQL> declare
2 type t_num is table of int index by pls_integer;
3 l_num t_num;
4
5 l_str varchar2(81) :='111111111122222221123333321123222321123212321123222321123333321122222221111111111';
6 begin
7 delete from t;
8
9 for i in 1..81 loop
10 insert into t values ( ceil(i/9),decode(mod(i,9),0,9,mod(i,9)),to_number(substr(l_str,i,1)));
11 end loop;
12
13 commit;
14 end;
15 /
PL/SQL procedure successfully completed
Executed in 0.017 seconds
|
|