| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
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_at_freelists.org on behalf of Deepak Sharma
Sent: Tue 10-10-2006 18:52
To: rjamya_at_gmail.com; kennaim_at_gmail.com
Cc: oracle-l_at_freelists.org
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'
> 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-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 12:51:17 CDT
 |
 |