Re: Merging three fields into one

Hello Daniel,

the concatenation operator in Oracle is ||.

So try

update tabname set targetfield = fieldsrc1 || fieldsrc2 || fieldsrc3;

Regards,

Martin

Daniel Cloutier wrote:
>
> Hello!
>
> I need to merge 3 fields into one single one. All fields are in the same table.
> So, I tried to do an UPDATE where it says UPDATE TABNAME SET TARGETFIELD =
> FIELDSRC1 & FIELDSRC2 & FIELDSRC3; but that doesnīt work. Instead, SQL Plus keeps
> asking me to provide a new value for 'FIELDSRC2' etc.
>
> Can someone please help me out here? I īm really stuck here.
>
> Thanks in advance!
>
> Bye,
> Daniel
>
> --
> __________________________________________________________
> News suchen, lesen, schreiben mit http://newsgroups.web.de
Received on Thu Dec 20 2001 - 02:19:59 CST