单条sql实现九九乘法表

已有 1027 次阅读2014-1-4 15:37 |个人分类:PL/SQL

select REVERSE (ltrim(sys_connect_by_path
                                           ( rpad( REVERSE(to_char(rownum * lv)),2)|| '=' ||rownum || '*' || lv
                                           ,
                                           ' ')
            ))
from (select level lv from dual connect by level < 10)
where lv = 1
connect by lv + 1 = prior lv ;