|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 21 of 166
CONCAT returns char1 concatenated with char2. Both char1 and char2 can be any of the datatypes
NCLOB. The string returned is of
VARCHAR2 datatype and is in the same character set as char1.
This function is equivalent to the concatenation operator (||).
"Concatenation Operator" for information on the
This example uses nesting to concatenate three character strings: