Concatenate (join) two strings in oracle using concat function

By Santhosh N

This explains how to concatenate two strings together in oracle.

Oracle has a function by the name, CONCAT which is used to merge or join or concatenate two strings together.

Syntax: CONCAT (str1, str2)

Ex: CONCAT (‘egg’, ‘headcafe’);
This returns ‘eggheadcafe’ as the result.

Related FAQs

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.
Oracle has a function to give the position of the char or string inside the string
Oracle provides a simple function to find and replace null values with the predefined values in select statements
What is the real purpose of dual in oracle.
Concatenate (join) two strings in oracle using concat function  (1955 Views)