fucntion已经写完了,谢谢附代码:CREATE OR REPLACE FUNCTION f_jf_companylist (tradeid IN VARCHAR2) RETURN VARCHAR2 IS str_return VARCHAR2 (2000); CURSOR c_tradeid (v_tradeid VARCHAR2) IS SELECT companyid FROM v_jf_company_display WHERE tradeid = v_tradeid; BEGIN FOR str_temp IN c_tradeid (tradeid) LOOP str_return := str_return || ',' || str_temp.companyid; END LOOP; RETURN str_return; END; /
RETURN VARCHAR2
IS
str_return VARCHAR2 (2000); CURSOR c_tradeid (v_tradeid VARCHAR2)
IS
SELECT companyid
FROM v_jf_company_display
WHERE tradeid = v_tradeid;
BEGIN
FOR str_temp IN c_tradeid (tradeid)
LOOP
str_return := str_return || ',' || str_temp.companyid;
END LOOP; RETURN str_return;
END;
/