Concatenar Colunas Oracle

SELECT Region_Name || ' ' || Store_Name FROM Geography
WHERE Store_Name = 'Boston';

Resultado:

'East Boston'