add html tag inside sql query result
<p>I am using oracle 11g, I have a sql query that returns a string type result_column with the following formatting of text (it's a concatenation obtained via the listagg function) :</p>

<p>aaa, bbbbbbb, cc, dddddddddd</p>

<p>I dont know the number of "operands", it can be 2, 3, 4 or even more...</p>

<p>I want to HTML format the result in order to alternate colors, so i want to transform the result column into :</p>

<pre><code>&lt;font color="red"&gt;aaa,&lt;/font&gt; &lt;font color="green"&gt;bbbbbbb,&lt;/font&gt; &lt;font      color="red"&gt;cc,&lt;/font&gt; &lt;font color="green"&gt;dddddddddd&lt;/font&gt;
</code></pre>

<p>is this possible ? (via regular expressions maybe ?)</p>

<p>In advance thank you very much for any tip you might give</p>

<p>Kind regards
Jam</p>