Cursor Value to Delimited String Variable??
From: M. Guest <mutantstar_at_hotmail.com>
Date: 4 Sep 2003 08:30:08 -0700
Message-ID: <4a37bfc4.0309040730.52c2046b_at_posting.google.com>
END LOOP;
s_AppSubType := x;
Date: 4 Sep 2003 08:30:08 -0700
Message-ID: <4a37bfc4.0309040730.52c2046b_at_posting.google.com>
Hello,
DECLARE s_AppSubType VarChar2(255);
DECLARE x VarChar2(255);
DECLARE y VarChar2(255);
DECLARE CURSOR ApplicationFor IS
SELECT InfoDesc FROM tbl1, tbl2 WHERE tbl1.folderrsn = argFolderRSN AND tbl1.infocode = tbl2.infocode; FOR ApplicationFor_cur IN ApplicationFor LOOP FETCH ApplicationFor INTO y; x := x ||', '|| y;
END LOOP;
s_AppSubType := x;
Sincerely,
Michelle
Received on Thu Sep 04 2003 - 17:30:08 CEST