This content has been marked as final. Show 5 replies
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.
field5 where field1 &' '& field2 &' '& field3 &' ' & field4 &' '& field5 = '12345' ;
where h.field1 &' '& h.field2 &' '& h.field3 &' ' & h.field4 &' '& h.field5 in '12345' ;
Thanks in advance.