CONCAT

CONCAT joins two expressions as a single character string.

Return Value

VARCHAR2 | NVARCHAR2 | CLOB | NCLOB

Syntax

CONCAT(char1, char2)

Arguments

char1 and char2 are text expressions.

Example

CONCAT('The current date is ', 'October 13, 2006') returns the string The current date is October 13, 2006.

Copyright © 2003, 2007, Oracle. All rights reserved.