Quick Search:
 
 The Oracle CONCAT Function      [Return To Index] Jump to:  

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:

Related Code Snippets:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org