Oracle - PL/SQL - CONCAT Function

In Oracle/PLSQL, the concat function allows you to concatenate two strings together.

The syntax for the concat function is:

concat( string1, string2 )

string1 is the first string to concatenate.

string2 is the second string to concatenate.

Applies To:

  • Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

concat('24X7', ' Information For You');

would return ‘24X7 Information For YouNet'.