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)