How can I concate address line 1,2,3 and city in oracle

Question

I am using CONCAT(CUSTOMER_ADDRESS_LINE1||,' ',CUSTOMER_ADDRESS_LINE2||,' ',CUSTOMER_ADDRESS_LINE3||,' ',CUSTOMER_CITY) but I am getting error message as Missing expressions.

[Concatenation Operator](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Concatenation-Operator.html#GUID-08C10738-706B-4290-B7CD-C279EBC90F7E) — astentx, Jul 12 '22 at 13:52

score 0 · Answer 1 · answered Jul 12 '22 at 13:32

0

You are mixing operators. Just use || to do all the concatenation:

CUSTOMER_ADDRESS_LINE1||' '||
CUSTOMER_ADDRESS_LINE2||' ' ||
CUSTOMER_ADDRESS_LINE3||' '||
CUSTOMER_CITY

answered Jul 12 '22 at 13:32

OldProgrammer

12,050
4
24
45

score 0 · Answer 2 · answered Jul 12 '22 at 13:34

0

SELECT
    CUSTOMER_ADDRESS_LINE1 || ' '
    || CUSTOMER_ADDRESS_LINE2 || ' '
    || CUSTOMER_ADDRESS_LINE3 || ' '
    || CUSTOMER_CITY
from table ..

answered Jul 12 '22 at 13:34

Ashish Patil

4,428
1
15
36

How can I concate address line 1,2,3 and city in oracle

2 Answers2