Hi,
My question is: How to concat values from several lines (the same
column) to only one value. For example:
We have table SGMENT with one column: NAME (varchar2(50)). We would
like to have as a query result the concatenation of names. I mean, for
example:
SGMENT
------
VS000_001_t
VS001_002_t
VS002_003_r
And with a query we would like to obtein:
"VS000_001_tVS001_002_tVS002_003_r"
Is this possible with only SQL Sentence as SELECT ....???
We are using IBM DB2 V7 UDB for OS390 AND ZOS
Thank you in advance
Regards
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG