Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle CONCAT Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: CONCAT

Definition:
The Oracle CONCAT function allows you to join (concatenate) two strings together.

CONCAT(string_1, string_2);

string_1 and string_2 are the two strings to be concatenated.

The || operator allows you to concatenate 2 or more strings together:

The syntax for the || operator is:

string_1 || string_2 || string_n;



'Sunday'|| ' May 15th' - returns 'Sunday May 15th'



'1' || '2' || '2' || '4' - returns '1234'

CONCAT may also be used in more complex expressions and statements:

standard.CONCAT(

lef    VARCHAR2 CHARACTER SET ANY_CS,

right  VARCHAR2 CHARACTER SET ANY_CS)

RETURN VARCHAR2 CHARACTER SET LEFT%CHARSET;

Related Links:

Oracle/PLSQL String Functions: CONCAT

Related Code Snippets:

Concatenate || - The || operator allows you to concatenate 2 or more strings together.
String Functions: CONCAT - Concatenates two or more strings.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: