Oracle SQL - how to find a match in a column with comma separated values?
<p>I have a column with type CLOB and contains comma separated values like '1,2,13,14' and i need to check if the value in another column (string) can match with any of the comma separated values in the CLOB. How do I do that?</p>

<p>eg. find if 3 is in '1,2,13,14'</p>

<p>I tried InStr and regexp_instr, they will both find a match when trying to see if 3 is in '1,2,13,14'</p>

<p>Please help!!</p>