PLSQL | CONCAT Function
Last Updated :
18 Sep, 2019
The string in PL/SQL is actually a sequence of characters with an optional size specification.
The characters could be numeric, letters, blank, special characters or a combination of all.
The CONCAT function allows you to concatenate two strings together. To CONCAT more than two values, we can nest multiple CONCAT function calls.
Syntax:
CONCAT( string1, string2 )
Parameters Used:
- string1: It is used to specify the first string to concatenate.
- string2: It is used to specify the second string to concatenate.
Supported Versions of Oracle/PLSQL:
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i
Example-1:
DECLARE
Test_String string(10) := 'Hello ';
Test_String2 string(10) := 'world!';
BEGIN
dbms_output.put_line(CONCAT(Test_String, Test_String2));
END;
Output:
Hello world!
Example-2:
DECLARE
Test_String string(10) := 'Geeks';
Test_String2 string(10) := 'For';
Test_String3 string(10) := 'Geeks';
BEGIN
dbms_output.put_line(CONCAT(CONCAT(Test_String, Test_String2), Test_String3));
END;
Output:
GeeksForGeeks
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...