Thursday, January 10, 2013

Concat Function


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

Syntax

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 11g, Oracle 10g, Oracle 9i, Oracle 8i

For Example

concat('Tech on', ' the Net');would return 'Tech on the Net'
concat('a', 'b')would return 'ab'