Concat function

If you have an indefinite number of values, you’ll need to use a database function.

This topic outlines how to do it in Oracle, including code that you can alter for your own purpose.