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是组合的维度 原文链接:https://www.f2er.com/oracle/208460.html
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是组合的维度 原文链接:https://www.f2er.com/oracle/208460.html