Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Merging three fields into one

Re: Merging three fields into one

From: Daniel Cloutier <danielcloutier_at_web.de>
Date: 03 Dec 2001 17:43:18 +0200
Message-ID: <3c0babb2@netnews.web.de>


davide_at_yahoo.com wrote:
>Daniel Cloutier <danielcloutier_at_web.de> wrote:
>The 'concatenation' operator is '||' in Oracle. Try
>
>update ... set field=field1 || field2 || field3

Thanks - that did it! I thought it would be something like && or & ... looking at Java and C(++) '||' is always used as OR. Well, I learned something new today :) ... Thanks again!

Bye, Daniel
>Davide

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de
Received on Mon Dec 03 2001 - 09:43:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US