Get startedGet started for free

Working with strings

Let's combine some information from multiple columns into a single output column. This time, you want to find out where the eSymphony employees are living.

In order to present your results in an organized way, you will use the concatenation operator, literal character strings, and the alternative quote operator that were introduced in the video.

This exercise is part of the course

Introduction to Oracle SQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Select the first name and country from the employee table
___ ___, ___
___ ___
Edit and Run Code