Re: Concetenating strings in PLSQL

From: marc parkinson <marcpark_at_starband.net>
Date: Fri, 18 Oct 2002 02:26:27 GMT
Message-ID: <JjKr9.5066$Rj.2387519635@twister1.starband.net>

Use the || function
for example

string_1 := string_2 || string_2;

Marc Parkinson

"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 Thu Oct 17 2002 - 21:26:27 CDT