中文字幕乱码亚洲无线精品一区,国产91精品一区二区绿帽 ,中文字幕日韩精品一区

Oracle ref 游標(biāo)

Posted on 2009-08-07 09:44 泰仔在線閱讀(232) 評(píng)論(0) 編輯收藏所屬分類: Oracle 相關(guān)

CREATE OR REPLACE FUNCTION GetAreaCdStr(cmpyCd IN varchar2) RETURN VARCHAR2 AS

TYPE REFCURSOR IS REF CURSOR;

AREA_COR REFCURSOR;

areaCdStr VARCHAR2(500);

areaCd VARCHAR2(3);

BEGIN

OPEN AREA_COR FOR

SELECT DISTINCT AREA_CD FROM T_AREA_M WHERE CMPY_CD = cmpyCd ORDER BY AREA_CD;

LOOP

FETCH AREA_COR INTO areaCd;

EXIT WHEN AREA_COR%NOTFOUND;

BEGIN

areaCdStr := areaCdStr || areaCd || ',';

END;

END LOOP;

CLOSE AREA_COR;

RETURN areaCdStr;

END;

調(diào)用:

SELECT T.CMPY_CD, T.CMPY_NM, GETAREACDSTR(T.CMPY_CD) AS AREACDSTR

FROM T_CMPY_M T

ORDER BY T.CMPY_CD


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: Oracle 系統(tǒng)變量使用 Oracle Connect By Start With 總結(jié)==轉(zhuǎn)帖 ORACLE UPDATE 語句語法與性能分析的一點(diǎn)看法(轉(zhuǎn)) Oracle ref 游標(biāo) MS SQL Server和Oracle的常用函數(shù)對(duì)比 ORACLE SEQUENCE學(xué)習(xí)