Re: Newbie question

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 ||
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "J_at_n Burgers" <j.burgers_at_hccnet.nl> wrote in message
> > news:a5g29j$q3v$1_at_news.hccnet.nl...
> > > My SQL query results in a id which consists of 3 different numbers. I
> want
> > > to concatinate these 3 numbers to one id number without spaces in
> between,
> > > but how???
> > > Anyone who can help??
> > > Jan Burgers
> > >
> > >
> >
> >
>
>
Received on Tue Feb 26 2002 - 09:20:51 CST