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: <davide_at_yahoo.com>
Date: 3 Dec 2001 14:34:18 GMT
Message-ID: <9ug2ha$82qo6$1@ID-18487.news.dfncis.de> 





Daniel Cloutier <danielcloutier_at_web.de> wrote:


> So, I tried to do an UPDATE where it says UPDATE TABNAME SET TARGETFIELD = 

> FIELDSRC1 & FIELDSRC2 & FIELDSRC3;



The 'concatenation' operator is '||' in Oracle. Try



update ... set field=field1 || field2 || field3



Davide
Received on Mon Dec 03 2001 - 08:34:18 CST












Original text of this message













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