How to split string by a special character and get into 2 separate variables in pl sql
<p>There is a text</p>
<blockquote>
<p>'example1,example2'</p>
</blockquote>
<p>I want to get this text into a 2 variables split by the comma.
So end result should be</p>
<blockquote>
<p>variable1 = 'example1'</p>
<p>variable2 = 'example2'</p>
</blockquote>
<p>How to do this on PL SQL ?</p>