Re: concatenating with oracle output

pawan_test schrieb:
> 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
>

You would have to use either
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/operators003.htm#i997789 or
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions026.htm#i77004

Best regards

Maxim Received on Tue Nov 14 2006 - 09:55:05 CST