concatenating two columns from oracle apex

Question

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?

Answer is fine, but it looks like you're using javascript syntax within Oracle SQL. Concat function would be more like concat(id, type) as joined_col — Scott
– Scott, Commented Nov 8, 2017 at 2:19

Kaushik Nayak · Accepted Answer · 2017-11-07 03:31:09Z

1

Try

Assuming this is a computation assigned to P3, try

:P3_ID ||  '.' || :P3_Type

Docs here and here.

edited Nov 7, 2017 at 3:31

Kaushik Nayak

31.9k6 gold badges36 silver badges54 bronze badges

answered Nov 7, 2017 at 1:21

Joe

3,3471 gold badge17 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

concatenating two columns from oracle apex

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related