|
123628056 发表于 2011-10-26 10:26
再请教一个问题。
如何连接的字符串排序? (因我提供的数据本身就是有序的)
-- 这样行不?
scott@TBWORA> with a as (select 1 A ,'a1' B from dual union all
2 select 1 , 'a2' from dual union all
3 select 2 , 'c' from dual union all
4 select 3 , 'f' from dual union all
5 select 4 , 'd1' from dual union all
6 select 4 , 'd2' from dual ),
7 b as (select ltrim(sys_connect_by_path(b,','),',') st
8 from a
9 where CONNECT_BY_ISLEAF=1
10 start with A=1
11 connect by prior A=A-1 )
12 select * from b
13 order by st;
ST
-------------------------------------------------------------------------------------
a1,c,f,d1
a1,c,f,d2
a2,c,f,d1
a2,c,f,d2
|
|