Shulou(Shulou.com)06/01 Report--

/ * Formatted on 2013-1-11 13:23:55 (QP5 v5.185.11230.41888) * /

Parameters of CREATE OR REPLACE FUNCTION GetGiftsName (rid in number) / / rid wear

RETURN VARCHAR2

AS

STR VARCHAR2 (1000); / * returned dataset * /

BEGIN

DECLARE

V_medCode VARCHAR2 (100); / * where temporary variables are stored * /

CURSOR D_cursor

IS

Select b.cproname from cc_promotions a left join cc_progifts b on a.ipromosid=b.ipromosid where a.ipromosid=rid and b.bgiftkeeper

BEGIN

OPEN D_cursor

Loop

Fetch D_cursor into v_medCode

EXIT WHEN D_cursor%NOTFOUND

If length (STR) > 0 THEN

STR: = STR | |','| | v_medCode

ELSE

STR: = STR | | v_medCode

END IF

END LOOP

Close D_cursor

End

RETURN STR

END GetGiftsName

Select GetGiftsName (428) from dual

The effect is that a field data under the same id can be queried and separated by commas (California West Plum, California West Plum 2)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.