sql语句如何实现排列组合?

shiyisaniya

select a.value||b.value result
from test_j a,test_j b
where a.rowid<>b.rowid
and a.value <b.value
order by result
-------------------------------------
result

ab
ac
ad
bc
bd
cd