I now use the set of transition function useful _concat, and returns the value type is set to clob, but in the implementation of the SQL, the database is too large, lead to database jammed, this what to do, beg god for help, thank you!!!!!!

CodePudding user response:

Your need, code and data volume and other issues also explain,

CodePudding user response:

You'll have to put your this custom function code post

If the patchwork of the long data, suggest points for more;

CodePudding user response:

SELECT * FROM (
SELECT A. *, ROWNUM RN FROM (
The select t.b ookname cc_concat (distinct d.d eptname) department, cc_concat (distinct p.c hinesename) personName, t.p ersonid
The from t_crm_book_range t left join t_crm_person p on t.r ange_personid=p.p ersonid
Left the join t_crm_dept d on p.org anid=d.d eptcode where 1=1
And t.com panyno='603886'
Group by t.b ookname, t.p ersonid
) A WHERE ROWNUM & lt; 100000
) p
WHERE an RN & gt;=1


Online zh_concat cc_concat () is the function and is the same, but the return value is the clob type

The amount of data has more than 10000 Chinese name

CodePudding user response:

That how many piece, can under specific said, please, thank you!!