ITPub博客

练练手，一句SQL实现输出九九乘法表 http://www.itpub.net/762215.html[@more@]select rn, ltrim(max(sys_connect_by_path(product, ',')), ',') productfrom ( select rn, product, min(product) over(partition by rn) product_min ,(row_number() over(order by rn, product)) + (dense_rank() over(order by rn)) numId from ( select b.rn, a.rn || '*' || b.rn || '=' || a.rn * b.rn product from (select rownum rn from all_objects where rownum <= 9) a, (select rownum rn from all_objects where rownum