Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SOLVED: Re: Getting all rows of sqlplus output on one line
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'
> yes, try it, it is very simple actually. I had done
> it some time ago.
>
> Raj
>
> On 10/9/06, Ken Naim <kennaim_at_gmail.com> 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,';'))
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 11:52:55 CDT
![]() |
![]() |