Re: concatenating with oracle output

From: pawan_test <sridhara007_at_gmail.com>
Date: 14 Nov 2006 08:05:38 -0800
Message-ID: <1163520338.455900.13750@e3g2000cwe.googlegroups.com>

thanks a lot

Maxim Demenko wrote:
> 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 - 10:05:38 CST