From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Using CONCAT

Using CONCAT - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial Buy for my team

Using CONCAT

“

- [Instructor] String concatenation allows us to chain multiple strings together, that is, combine the values of multiple varchar data types or string retrieved by a SQL query into one longer string value. Let's see an example. We'll start by selecting the first name and last name values from our employees table. We can concatenate or combine the values of first name and last name so that instead of the SQL query returning name in two distinctly different columns, which is how the data is stored in the table, the SQL query can return them as one concatenated string. We simply do that by adding concat, which is the name of the function, and then inside brackets, specify the two column values we want to combine together or concatenate together. Running this query, we see that we got a combined output of both columns. We can also use concat and combine a literal string with the value retrieved from a database column. So for…

Contents