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:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 65 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?