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' |
