ORACLE SQL TUTORIAL: How to COMBINE Two Columns into one COLUMN | CONCATENATE TWO COLUMNS

How to combine, join, merge two colums or more and into one column with || pie operator

Code:
-- whitout group by
select FIRSTNAME || ' ' || LASTNAME || ' ' || GENDER as fullname_gender, -- ... more value
geographykey
from dimcustomer;

-- in Case of group by
select count(GEOGRAPHYKEY),
FIRSTNAME || ' ' || LASTNAME as FULLNAME
from dimcustomer
group by
FIRSTNAME, LASTNAME;

👉 ACCESS webpage ►

★NETWORKS (FOLLOW US)★

★DOWNLOAD OUR APPS FOR ANDROID★

Remember that these videos are for educational purposes.