RE: Can I concatenate several rows without a procedure?

Humm, what purpose would that serve? How would that be useful? My perception is a row of data is independently referenced and if you concat n rows into one string... the data would no longer be referenced individually.

No doubt someone on this list can give you a solution, but Im sure it would need to be in a procedure, looping thru and concating as it went... which was not your original criteria.

-----Original Message-----
Sent: Tuesday, October 21, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
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).