Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question
Thanx...
"Jon Yi" <jon.yi_at_verizon.net> wrote in message
news:nJNe8.587$E11.399_at_nwrddc02.gnilink.net...
> In any Oracle book, you will find this in chapter 1. Why not do a little
> reading first???
> SQL does not care if it is a number or a char. "||" will put all the
columns
> together into one.
>
> select col1 || col2 || col3 from my_table;
>
> "J_at_n Burgers" <j.burgers_at_hccnet.nl> wrote in message
> news:a5g71e$1g5$1_at_news.hccnet.nl...
> > Ok, but the 3 numbers are in 3 different columns. So how to concatenate
> the
> > 3 numbers to one number in one column???
> >
> > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message
> > news:3c7b96c1$0$8510$ed9e5944_at_reading.news.pipex.net...
> > > the oracle concatenation operator is ||
> > >
> > >
> > > --
Received on Tue Feb 26 2002 - 11:12:41 CST