Re: concatenating with oracle output

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

The answer at 07:47:47 (GMT -0800) is the same as at 07:45:45 (GMT -0800). ;-)

The answer also depends on where the values of 'd' and 'e' come from and what programming environment you are planning on doing this in. A simple SQL script? PL/SQL? Java? Received on Tue Nov 14 2006 - 10:09:02 CST