posts - 0,  comments - 0,  trackbacks - 0

select r1 || '*' || r1 || '=' || r1 * r1 A,
decode(r2, '', '', r2 || '*' || r1 || '=' || r2 * r1) b,
decode(r3, '', '', r3 || '*' || r1 || '=' || r3 * r1) C,
decode(r4, '', '', r4 || '*' || r1 || '=' || r4 * r1) D,
decode(r5, '', '', r5 || '*' || r1 || '=' || r5 * r1) E,
decode(r6, '', '', r6 || '*' || r1 || '=' || r6 * r1) F,
decode(r7, '', '', r7 || '*' || r1 || '=' || r7 * r1) G,
decode(r8, '', '', r8 || '*' || r1 || '=' || r8 * r1) H,
decode(r9, '', '', r9 || '*' || r1 || '=' || r9 * r1) I
from (select level r1,
lag(level, 1) over(order by level) r2,
lag(level, 2) over(order by level) r3,
lag(level, 3) over(order by level) r4,
lag(level, 4) over(order by level) r5,
lag(level, 5) over(order by level) r6,
lag(level, 6) over(order by level) r7,
lag(level, 7) over(order by level) r8,
lag(level, 8) over(order by level) r9
from dual
connect by level < 10)

 


select rn, ltrim(max(sys_connect_by_path(product, ',')), ',') product
from
(
  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 <= 9) b
    where a.rn <= b.rn
    order by b.rn, product
  )
)
start with product = product_min
connect by numId - 1 = prior numId
group by rn
order by rn

 

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


 

posted on 2007-09-27 14:41 Johnson 阅读(161) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航:
 
<2025年7月>
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

留言簿

文章分类

文章档案

搜索

  •  

最新评论