From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Concatenation
- [Instructor] Outside of Oracle 19c Databases, you've probably heard of catenation in chemistry, the bonding of atoms of the same element in a series. In Oracle Database 19c, there is a similar concept called concatenation, which combines two or more columns or expressions together in a single string result. I'll go over the different ways you can perform concatenation and what happens when you try to concatenate nine character strings with character strings. Looking at the dictionary definitions of concatenation and catenation, they are both similar to what Oracle Database 19c does, but in Oracle Database 19c, it's commonly known as string concatenation. No matter what you call it, when you concatenate two or more columns, constants or expressions, you end up with a single variable length string. There are two different ways you can concatenate. In Oracle Database 19c, you can use two vertical bars between two strings, columns or expressions. You can also concatenate using the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.