Re: SOLVED: Re: Getting all rows of sqlplus output on one line

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Tue, 10 Oct 2006 09:52:55 -0700 (PDT)
Message-ID: <20061010165255.92084.qmail@web52811.mail.yahoo.com>

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_at_gmail.com> wrote:

> 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,';'))

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 10 2006 - 11:52:55 CDT