Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

New function CONCAT_WS

Thorsten KettnerMar 25 2020 — edited Nov 26 2020

PostgreSQL, MySQL and SQL Server have the function CONCAT_WS to concatenate strings with a separator. NULL strings are ignored. Admittedly, this is a function that is seldom needed, but in the rare cases were appropriate, this function can be very convienient. I suggest to introduce this function in Oracle, too.

Example:

SELECT CONCAT_WS(' ', title, first_name, last_name) AS name FROM persons;

NAME

---------------

Mrs. Jane Smith

Hank Miller

Mr. Jones

Comments
Post Details
Added on Mar 25 2020
5 comments
3,620 views