Oracle PL/SQL Concat Function

The concat function allows us to concatenate two strings together.

The Concat Function syntax:

concat( string1, string2 )

Example:

select concat('PL', ' SQL Tutorial') from dual;
would return 'PL SQL Tutorial'


select concat('x', 'y') from dual;
would return 'xy'