Oracle SQL Concatenate string based of value of another column

Question

I have tried looking up this issue but maybe I'm just not searching correctly.

I was wondering if its possible in SQL to concatenate based off the results of another column in the same row. Let me give an example

+-------------+------------+--------+
|    STATE    |    CITY    | Region |
+-------------+------------+--------+
| Georgia     | Atlanta    | East   |
| Los Angeles | California | West   |
+-------------+------------+--------+

Lets say I have this table and I want to make a new column in it by doing some kind of concatenation

The output should look like this

+-----------+------------+-------------+--------+
|   SIDE    |   STATE    |    CITY     | Region |
+-----------+------------+-------------+--------+
| East_Side | Georgia    | Atlanta     | East   |
| West_Side | California | Los Angeles | West   |
+-----------+------------+-------------+--------+

So the Side column should look into region and ask What Region is it? And then say ok so this is "?_Side" Then concatenate the appropriate "Region_Side" = "East_Side"

This is just a simple example, I know in this example I could use a case statement but in my actual application I can't since its a lot of "Regions"

Is this possible or no?

Gordon Linoff · Accepted Answer · 2018-04-06 18:58:12Z

2

Does this do what you want?

select Region || '_Side', state, city, region
from t;

|| is the string concatenation operator in Oracle (and in standard SQL as well).

answered Apr 6, 2018 at 18:58

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

ScaisEdge · Accepted Answer · 2018-04-06 18:59:23Z

1

Just use column and concat the string

select  region ||'_Side', STATE ,  CITY , Region
from my_table

answered Apr 6, 2018 at 18:59

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Collectives™ on Stack Overflow

Oracle SQL Concatenate string based of value of another column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related