IniziaInizia gratis

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.

Questo esercizio fa parte del corso

Introduction to Oracle SQL

Visualizza il corso

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

-- Select the first name and country from the employee table
___ ___, ___
___ ___
Modifica ed esegui il codice