山东建设报网站,汽车业务网站开发公司,宿城区住房和城乡建设局网站,西安建设工程交易网不好意思#xff0c;编译错误#xff0c;可能是版本的问题其实#xff0c;实现的方法很简单#xff0c;请参考精华帖子下面是源文件 #xff0c;我是的数据库版本是9.2.0.1#xff0c;OS为NT[PHP]---Author: Accelerator---Date : 2004-11-25create or replace type lis…不好意思编译错误可能是版本的问题其实实现的方法很简单请参考精华帖子下面是源文件 我是的数据库版本是9.2.0.1OS为NT[PHP]---Author: Accelerator---Date : 2004-11-25create or replace type list_agg as object(total varchar2(4000),static functionODCIAggregateInitialize(sctx IN OUT list_agg )return number,member functionODCIAggregateIterate(self IN OUT list_agg ,value IN varchar2 )return number,member functionODCIAggregateTerminate(self IN list_agg,returnValue OUT varchar2,flags IN number)return number,member functionODCIAggregateMerge(self IN OUT list_agg,ctx2 IN list_agg)return number);/create or replace type body list_aggisstatic function ODCIAggregateInitialize(sctx IN OUT list_agg)return numberisbeginsctx : list_agg(null);return ODCIConst.Success;end;member function ODCIAggregateIterate(self IN OUT list_agg,value IN varchar2 )return numberisbeginself.total : self.total||,||value;return ODCIConst.Success;end;member function ODCIAggregateTerminate(self IN list_agg,returnValue OUT varchar2,flags IN number)return numberisbeginreturnValue : substr(self.total,2);return ODCIConst.Success;end;member function ODCIAggregateMerge(self IN OUT list_agg,ctx2 IN list_agg)return numberisbeginself.total : self.total||ctx2.total;return ODCIConst.Success;end;end;/CREATE OR REPLACE FUNCTION list(input varchar2 )RETURN varchar2PARALLEL_ENABLE AGGREGATE USING list_agg;/[/PHP]
