经典SQL-2

利用SQL实现1-n全排列

with tmp as (select level l from dual connect by level<=4)
select sys_connect_by_path(l,',')
from tmp
where level=4
connect by nocycle l<>prior l;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12801008/viewspace-1024359/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12801008/viewspace-1024359/