单条sql实现九九乘法表
已有 1028 次阅读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 ;