Name

concat — Concatenate strings

Synopsis

concat ( str1 varchar ,
  str2 varchar ,
  ... ,
  strn varchar );
 

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 .

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 .

Errors

Table 24.15. Errors signalled by concat()

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

Example 24.47. Simple Example

Cross a mule with an ass.

SQL> select concat ('Muuli', 'aasi');
callret
VARCHAR
_______________________________________________________________________________

Muuliaasi

1 Rows. -- 4 msec.