首页天道酬勤oracle数据去重方法,oracle 去重查询

oracle数据去重方法,oracle 去重查询

张世龙 05-12 05:33 20次浏览

Oracle sprite字符串函数(去氢和去氢() () ) ) ) )。

1 .不去沉重的FUNCTION f_link

Function f_link

createorreplacefunctionf _ link (p _ str varchar2) )。

return varchar2parallel _ enable aggregate

USING t_link;

Type t_link

createorreplacetypet _ linkasobject

StrVarchar2(30000 )、

-currentsepratorvarchar2(8、

staticfunctionodciaggregateinitialize (sctxinoutt _ link )返回编号,

memberfunctionodciaggregateiterate (selfinoutt _ link,

valueinvarchar2(返回编号,

memberfunctionodciaggregateterminate (self int _ link,

返回value out varchar 2,

flags IN NUMBER )

返回编号是,

memberfunctionodciaggregatemerge (selfinoutt _ link,ctx2 IN t_link ) )。

返回编号

createorreplacetypebodyt _ linkis

staticfunctionodciaggregateinitialize (sctxinoutt _ link ) RETURN NUMBER IS

比根

stx :=t _ link (空;

RETURN odciconst.success;

结束;

memberfunctionodciaggregateiterate (selfinoutt _ link,

valueinvarchar2(returnnumberisbegin

SELF.str :=SELF.str ||; “| |值;

RETURN odciconst.success;

结束;

memberfunctionodciaggregateterminate (self int _ link,

返回value out varchar 2,

oracle中拼接字符串,sqlserver拼接字符串