select trim(both '#' from sys_connect_by_path (公司, '#')) as combo
from TP_COMPANYSINGLE
WHERE LEVEL=50
connect by rowid < prior rowid AND LEVEL <=50;
其中50是组合的维度
Oracle 查询结果组合
最新推荐文章于 2023-03-24 13:23:31 发布
select trim(both '#' from sys_connect_by_path (公司, '#')) as combo
from TP_COMPANYSINGLE
WHERE LEVEL=50
connect by rowid < prior rowid AND LEVEL <=50;
其中50是组合的维度