SQL REVERSE 及九九乘法表

oracle 提供一个reverse函数,可以实现将一个对象反向转换.
比如:
SQL> select reverse('123456') from dual; 

SELECT REVERSE(sys_connect_by_path(REVERSE(rpad(rownum * lv, 2)) || '=' ||
                                    rownum || '*' || lv,
                                    '
'))
  FROM (SELECT LEVEL lv FROM dual CONNECT BY LEVEL < 10) t
 WHERE lv = 1
CONNECT BY lv + 1 = PRIOR lv;

 

posted @ 2018-05-23 16:39  航松先生  阅读(316)  评论(0)    收藏  举报