Re: Can I concatenate several rows without a procedure?

The following query returns 33 records.

SYS0 freestyle!! 12-MAY-02
SYSTEM5 freestyle!! 12-MAY-02
OUTLN11 freestyle!! 12-MAY-02
....

But, I would like to have all 33 records appended together to have one long record.

SYS0 freestyle!! 12-MAY-02SYSTEM5 freestyle!! 12-MAY-02OUTLN11 freestyle!! 12-MAY-02....

Thanks again,
Jake

On Tue, Oct 21, 2003 at 07:49:25AM -0800, Bob Metelsky wrote:
> select username||user_id||' freestyle!! '|| created as concat from
> all_users;
>
>
> Hello,
> I am trying to concatenate several records with simple sql. Is this
> possible?
>
>
> --
> Thanks,
> Jake Johnson
> jake_at_plutoid.com
>
> ______________________________________________________________________
> Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
> Rims, Tires, and Wheel Packages.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jake Johnson
> INET: jake_at_plutoid.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Bob Metelsky
> INET: bmetelsky_at_cps92.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Thanks,
Jake Johnson
jake_at_plutoid.com

______________________________________________________________________
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Tires, and Wheel Packages.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jake Johnson
  INET: jake_at_plutoid.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).