5 Replies Latest reply: May 15, 2018 1:37 PM by Sasidhar Parupudi RSS

    Concatenation syntax help

    bhavani b

      Hi Experts,

       

      Can any one please help me on below requirement.

      I have 5 fields in oracle table in qlik like below. I have to concatenate these 5 fields and need to apply where condition on one record.

      In qlik will do concatenation like with where condition where field1 &' '& field2 &' '&  field3 &' ' & field4 &' '&  field5 = '12345'  ;

      I need the same concatenation syntax  in oracle to pass at Select statement. Please help me how to do field concatenation in Oracle what changes i need to made at red color highlighted line.

       

       

      Table:

      Load

      field1,

      field2,

      field3,

      field4,

      field5 where field1 &' '& field2 &' '&  field3 &' ' & field4 &' '&  field5 = '12345'  ;

       

      Select

      h.field1,

      h.field2,

      h.field3,

      h.field4,

      h.field5

      from db.TEST

      where h.field1 &' '& h.field2 &' '&  h.field3 &' ' & h.field4 &' '&  h.field5   in  '12345'  ;


      Thanks in advance.

       

      jyothish8807

      sasiparupudi1

      petter-s