Re: SOLVED: Re: Getting all rows of sqlplus output on one line
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: rjamya@xxxxxxxxx, kennaim@xxxxxxxxx
- Date: Tue, 10 Oct 2006 09:52:55 -0700 (PDT)
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
Other related posts:
