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;


浙公网安备 33010602011771号