Re: Concetenating strings in PLSQL

Ciao Enrico.

You concatenate using the || operator, for instance:

select ename || ' (' || deptno || ')'
from emp
order by ename;

HTH. Finn

"Odd Morten Sveås" <odd.morten.sveas_at_accenture.com> wrote in message news:4306a83.0210181211.7c5ab7c_at_posting.google.com...
> enrlucNOSAM_at_inwind.SPAM.it (Enrico Luciano) wrote in message
news:<3dac4d2e.9414226_at_powernews.libero.it>...
> > Hi all,
> > i'm trying to concatenate some string variables (varchar2) in
> > PLSQL. I've found only the LPAD, RPAD functions to do that.
> >
> > Is there any other (simpler) way to do this? Is there any package/SQL
> > function that can help?
> >
> > I'm not too expert in pl/sql programming.. I tried to look for docs
> > but I've found nothind..
> >
> > thank you in advance
> > Enrico
>
> Try the otn.oracle.com for oracle docs. This surely would be well
> documentated. I just performed a search here in google groups: I got
> 517 hits on the string: oracle sql concatenate.
> I'm so lazy, and usualy in such a hurry that always google first, and
> if that don't help, eventualy I post a question here.
>
> Sorry if I seem grumphy, it not my intention.
> Rgds
> Odd Morten
Received on Sat Oct 19 2002 - 04:23:44 CDT