Definition Function Create or Replace Function F_JF_companylist (Tradeid In Varchar2) Return Varchar2is Str_RETURN VARCHAR2 (2000)
CURSOR c_tradeid (v_tradeid VARCHAR2) IS SELECT id FROM a1 WHERE id = v_tradeid; BEGIN FOR str_temp IN c_tradeid (tradeid) LOOP str_return: = str_return || ',' || str_temp.id; END LOOP;
Return Str_Return;
Execute SQL> Declare 2 Str: = f_jf_companylist ('proYang1'); 5 dbms_output.put_line ('return value is' || str); 6 end; 7 / return value, proYang1 , Proyang1, Proyang1, Proyang1, Proyang1, Proyang1, Proyang1, Proyang1, Proyang1, Proyang1
The PL / SQL process has been successfully completed.
