OracleString FunctionsCONCAT

CONCATString Functions

SUBSTR

Concatenates two strings (equivalent to the || operator).

Syntax

CONCAT(s1, s2)

Example

Enter values below to update the example in real time.

first_name
last_name
full_name
employees
SELECT CONCAT(first_name, ' ' || last_name) AS full_name
FROM employees;