Concatenate columns

From: Sashi <smalladi_at_gmail.com>
Date: Thu, 18 Oct 2007 13:02:39 -0700
Message-ID: <1192737759.970098.290020@e9g2000prf.googlegroups.com>

Hi all,

Is it possible to concatenate the columns of the results of a query without having to run it through an external filter?

For examples, if I have
select col-A, col-B, col-C, col-D from my_table.

Can I write the query such that col-A, col-B and col-C come out concatenated? Yes, they're the same data type.

So I'm looking for something like
select col-A + col-B + col-C, col-D where "+" is a concatenation operator.

Thanks a lot!
Sashi Received on Thu Oct 18 2007 - 15:02:39 CDT