-
orcale 函数wm_concat不存咋lob值使用zh_concat 替换
- create or replace TYPE zh_concat_im
- AUTHID CURRENT_USER AS OBJECT
- (
- CURR_STR VARCHAR2(32767),
- STATIC FUNCTION ODCIAGGREGATEINITIALIZE(SCTX IN OUT zh_concat_im) RETURN NUMBER,
- MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT zh_concat_im,
- P1 IN VARCHAR2) RETURN NUMBER,
- MEMBER FUNCTION ODCIAGGREGATETERMINATE(SELF IN zh_concat_im,
- RETURNVALUE OUT VARCHAR2,
- FLAGS IN NUMBER)
- RETURN NUMBER,
- MEMBER FUNCTION ODCIAGGREGATEMERGE(SELF IN OUT zh_concat_im,
- SCTX2 IN zh_concat_im) RETURN NUMBER
- );
- /
-
- create or replace TYPE BODY zh_concat_im
- IS
- STATIC FUNCTION ODCIAGGREGATEINITIALIZE(SCTX IN OUT zh_concat_im)
- RETURN NUMBER
- IS
- BEGIN
- SCTX := zh_concat_im(NULL) ;
- RETURN ODCICONST.SUCCESS;
- END;
- MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT zh_concat_im,
- P1 IN VARCHAR2)
- RETURN NUMBER
- IS
- BEGIN
- IF(CURR_STR IS NOT NULL) THEN
- CURR_STR := CURR_STR || <span style="color:#ff0000;">','</span> || P1;
- ELSE
- CURR_STR := P1;
- END IF;
- RETURN ODCICONST.SUCCESS;
- END;
- MEMBER FUNCTION ODCIAGGREGATETERMINATE(SELF IN zh_concat_im,
- RETURNVALUE OUT VARCHAR2,
- FLAGS IN NUMBER)
- RETURN NUMBER
- IS
- BEGIN
- RETURNVALUE := CURR_STR ;
- RETURN ODCICONST.SUCCESS;
- END;
- MEMBER FUNCTION ODCIAGGREGATEMERGE(SELF IN OUT zh_concat_im,
- SCTX2 IN zh_concat_im)
- RETURN NUMBER
- IS
- BEGIN
- IF(SCTX2.CURR_STR IS NOT NULL) THEN
- SELF.CURR_STR := SELF.CURR_STR || <span style="color:#ff0000;">','</span> || SCTX2.CURR_STR ;
- END IF;
- RETURN ODCICONST.SUCCESS;
- END;
- END;
- /
- create or replace FUNCTION zh_concat(P1 VARCHAR2)
- RETURN VARCHAR2 AGGREGATE USING zh_concat_im ;
-
相关阅读:
安装SQL sever2008时显示重新启动计算机规则失败,应该怎么解决?
C#获取当前日期时间(转)
使用JQUERY实现页面局部刷新
Metal渲染:实现画面比例功能
Metal渲染:实现旋转/翻转功能
依赖注入浅析
iOS 消息推送实现 APNS
使用#pragma阻止一些warnings
github 多帐户使用
Swift 实现Bitmask Option(Enum)
-
原文地址:https://www.cnblogs.com/itniwota/p/6481353.html
Copyright © 2020-2023
润新知