RE: SOLVED: Re: Getting all rows of sqlplus output on one line
- From: "Marco Gralike" <Marco.Gralike@xxxxxxx>
- To: <sharmakdeep_oracle@xxxxxxxxx>, <rjamya@xxxxxxxxx>, <kennaim@xxxxxxxxx>
- Date: Tue, 10 Oct 2006 19:51:17 +0200
I have NO idea what you wrote about, but google gave me the answer within two
clicks and typing one word "stragg". Look simple to me...
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2196162600402
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Deepak Sharma
Sent: Tue 10-10-2006 18:52
To: rjamya@xxxxxxxxx; kennaim@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: 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'
--- 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 <http://mail.yahoo.com/>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
