Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Merging three fields into one
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.deReceived on Mon Dec 03 2001 - 09:43:18 CST