How? select stragg(username,';') users from dba_users where username like 'SYS%' order by username / select stragg(username,';') users * ERROR at line 1: ORA-06553: PLS-306: wrong number or types of arguments in call to 'STRAGG' --- rjamya <rjamya@xxxxxxxxx> wrote: > yes, try it, it is very simple actually. I had done > it some time ago. > > Raj > > On 10/9/06, Ken Naim <kennaim@xxxxxxxxx> wrote: > > Is there a way to modify the stragg and > ODCIAggregateIterate function to > > accept a variable for the separator. I used a > replace around the stragg > > function but was wondering if it would be possible > (ex: stragg(col,';')) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l