SELECT member_id, 
       Substr(Wm_concat(address), 0, 2000) email 
FROM   t 
GROUP  BY member_id;

column owner format a6
column object_name format a9
column object_type format a8

SELECT owner, 
       object_name, 
       object_type 
FROM   dba_objects 
WHERE  object_name = Upper('wm_concat'); 

SYS@poznan>SELECT owner, object_name, object_type FROM dba_objects WHERE object_name=upper('wm_concat');

OWNER  OBJECT_NA OBJECT_T
------ --------- --------
PUBLIC WM_CONCAT SYNONYM
WMSYS  WM_CONCAT FUNCTION

owmctab.plb