Oracle: 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('Tech on', ' the Net'); would return 'Tech on the Net'.
concat('a', 'b') would return 'ab'.

Thanks,
Info source: http://www.techonthenet.com/oracle/functions/concat.php