PLSQL | CONCAT Function Last Updated : 18 Sep, 2019 Comments Improve Suggest changes Like Article Like Report 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 Comment More infoAdvertise with us Next Article PLSQL | CONCAT Function S Shubrodeep Banerjee Follow Improve Article Tags : SQL SQL-PL/SQL Similar Reads PLSQL | CONVERT Function 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 CONVERT function in PLSQL is used to convert a string from one character set to another. Generally, the dest 2 min read CONCAT() function in MySQL CONCAT() function in MySQL is used to concatenating the given arguments. It may have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. If a numeric argument is given then it is 2 min read MySQL | Group_CONCAT() Function The GROUP_CONCAT() function in MySQL is an aggregation function that combines data from multiple rows into a single string. It is particularly useful for aggregating summaries, such as combining related information into a single field for better readability or reporting. In this article, we will exp 4 min read MySQL | CONV( ) Function The MySQL CONV() function is used for converting a number from one numeric base system to another. The value returned by the CONV() function is in the form of a string value. It accepts three parameters which are the value to be converted, the current numeric base system and the numeric base system 2 min read Inbuilt Concat Function in PLSQL Prerequisite : PLSQL BASICS Introduction : PLSQL stands for "Procedural Language extensions to SQL" and is used to transform, update and query data in a database. It is grouped into blocks that contain the declaration and statements. And it is integrated with the oracle database (since version 7). A 3 min read Like