Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 21 of 166
concat::=
concat
CONCAT
returns char1 concatenated with char2. Both char1 and char2 can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, NVARCHAR2
, CLOB
, or 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 (||).
This example uses nesting to concatenate three character strings:
SELECT CONCAT(CONCAT(last_name, '''s job category is '), job_id) "Job" FROM employees WHERE employee_id = 152; Job ------------------------------------------------------ Hall's job category is SA_REP
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|