Seamless concatenation via Varargs

Version

23.2
Categories

SQL

You can now concatenate an unlimited number of parameters via the CONCAT() function.

SELECT CONCAT('Hello World! It currently is ', TO_CHAR(sysdate,'YYYY-MM-DD HH24:MI:SS'), ' here in Vienna.') AS my_string;
Result
SQL> SELECT CONCAT('Hello World! It currently is ', TO_CHAR(sysdate,'YYYY-MM-DD HH24:MI:SS'), ' here in Vienna.') AS my_string;

MY_STRING
___________________________________________________________________
Hello World! It currently is 2024-06-13 16:50:50 here in Vienna.

Benefits

Not having to nest multiple concatenations in multiple CONCAT() calls aids the readability and maintainability of code.

Further information