Just use bars ||
eg
'one string'||'two string'
makes
'one stringtwo string'
Look in the sql reference manual
Jim
"Enrico Luciano" <enrlucNOSAM_at_inwind.SPAM.it> 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
>
Received on Tue Oct 15 2002 - 12:26:49 CDT
