Search code examples
plsqloracle-apexstring-concatenation

concatenating two columns from oracle apex

I am trying to concatenate 2 columns from oracle apex to fill out one of the column. P3_ID contains text data like 09842 and P3_Type also contains data like 04214. I am trying to concatenate P3_ID +'.'+P3_Type (09842.04214) to put it into p3_total. So I add default value into P3_total to

select concat('P3_ID'+'.'+'P3_Type') from dual;

but It doesn't work for me. Does anyone have an idea to make p3_total to work?

Solution

  • Try

    Assuming this is a computation assigned to P3, try

    :P3_ID ||  '.' || :P3_Type

    Docs here and here.