concat
Concatenate strings
concat
( str1 varchar,
str2 varchar,
... ,
strn varchar);
Parameters
Concat takes a variable number of string
arguments.
Return types
The concat returns a single
string. If there are wide strings amongst
the arguments, the string returned will also be
wide.
Description
concat returns a new string,
concatenated from a variable number of strings given as
arguments. NULL arguments are handled as empty strings.
concat (str) returns a copy of
str.
concat () returns an empty
string.
Errors
sqlstate |
error code |
error text |
22023
|
SR007
|
Function concat needs a string or NULL as argument
<argument number>, not an arg of
type <offending type>
|
Examples
Simple Example
Cross a mule with an ass.
SQL> select concat ('Muuli', 'aasi');
callret
VARCHAR
_______________________________________________________________________________
Muuliaasi
1 Rows. -- 4 msec.