concatenate (join) multiple strings in oracle using || operator

By Santhosh N

This explains how to concatenate multiple strings together in oracle.

In oracle, other than CONCAT to concatenate two strings, one could concatenate multiple strings using || operator. This || operator is used to concatenate multiple strings together into one string

Syntax: str1||str2 || str3 || strN

Ex: 'egg' || 'head' || 'cafe'
This returns 'eggheadcafe' as the result.

Related FAQs

This explains how to concatenate two strings together in oracle.
This explains how to get the character of the desired Ascii code in oracle.
This explains how to convert any character set strings to ascii character set strings in oracle.
This explains how to get the ascii code of the desired character in oracle.
What is the real purpose of dual in oracle.
Used to check if the column value is in numeric format
concatenate (join) multiple strings in oracle using || operator  (2883 Views)