最近在做一新项目涉及到复杂的查询,其中就包括需要将多行数据转化为一行显示,在网上Google了一把然后自己改了一点就可以用了,记录下来以为后用.
第一步: 新建Types类型:
create or replace type combStrType as object
(
currentstr varchar2(4000),
currentseprator varchar2(8),
static function ODCIAggregateInitialize(sctx IN OUT combStrType) return number,
member function ODCIAggregateIterate(self IN OUT combStrType, value IN VARCHAR2) return number,
member function ODCIAggregateTerminate(self IN combStrType, returnValue OUT VARCHAR2, flags IN number) return number,
member function ODCIAggregateMerge(self IN OUT combStrType, ctx2 IN combStrType) return number
);