create or replace FUNCTION rawstrcat (input nvarchar2) RETURN nvarchar2
PARALLEL_ENABLE AGGREGATE USING rawstr;

Select Wod.MlotID, rawstrcat(waferNo) from wafertestorderdetail wod
join wafertestorder wo on wod.wafertestorderid = wo.wafertestorderid
left join (
select *
from wafertestorderfailture
) wof on wof.wafertestorderdetailid = wod.wafertestorderdetailid
Where WafertestorderDetailID =2360
group by MlotID;

Oracle 多行记录合并方法