Re: concatenating with oracle output

From: Glen <stromqueat_at_teldotnet.com>
Date: Tue, 14 Nov 2006 16:03:29 GMT
Message-ID: <lNl6h.3613$b07.156@clgrps13>

pawan_test wrote:
> Hi All,
>
> i have a question regarding the oracle database.
> i have a table say table1
>
> select a,b,c from table1;
>
> i have d=10 and e=5
>
> i have to append the values of d and e to the output of the above query
>
> the ouput might look like; a b c 10 5
>
> can anyone please suggest me how do I do it in oracle
>
> thanks
> mark
>

concatenate operator in Oracle is ||

so, select a,b,c,d||e from table1; or select a,b,c||d||e from table1;, depending how you want it to look...

hth Received on Tue Nov 14 2006 - 10:03:29 CST