蜜芽笔试题:
-打印1 22 33 444 555 6666 77777 88888 9999 10101010 1111111111 1212121212
with dao as
(select level c1 from dual connect by level <= 5)
select lpad(rownum, c2 * length(rownum), rownum)
from (select d1.c1 c1, d2.c1 c2
from dao d1, dao d2
where d1.c1 <= d2.c1
order by d2.c1)
结果
1
22
33
444
555
666
7777
8888
9999
10101010
1111111111
1212121212
1313131313
1414141414
1515151515
15 rows selected