What is the usage of concat function in oracle?

1 year ago
Liam
1 minute

In Oracle, the CONCAT function is used to combine two or more strings.

Syntax:
CONCAT(string1, string2)

Arguments:

  1. string1: the first string to be connected
  2. The second string to be connected.

Example:
SELECT CONCAT(‘Hello’, ‘ ‘, ‘World’) FROM dual;
Result: Hello World

Please note:

  1. The CONCAT function can combine multiple strings by simply listing the strings to be joined in order.
  2. If there is a NULL value in the strings to be concatenated, the CONCAT function will return NULL.
  3. The CONCAT function can be used in conjunction with other string functions, such as SUBSTR, UPPER, LOWER, and so on.
bannerAds