Oracle 函数默认用逗号连接数据列

create or replace
function       CONCAT_COL (input varchar2) return varchar2
    parallel_enable aggregate using CONCAT_COL_IMPL;

 

 create or replace
type       CONCAT_COL_IMPL as object
(
    CATVALS varchar2(4000),
    static function ODCIAggregateInitialize(sctx  in out CONCAT_COL_IMPL) return number,
    member function ODCIAggregateIterate(self  in out CONCAT_COL_IMPL, value in varchar2 ) return number,
    member function ODCIAggregateTerminate(self in CONCAT_COL_IMPL, return_value out varchar2, flags in number) return number,
    member function ODCIAggregateMerge(self in out CONCAT_COL_IMPL, ctx2 in CONCAT_COL_IMPL) return number
);