title: SQL (oracle) to compare two lists
body: <p>I have a table with a column containing a list (yes I know this violates normalization). I'm trying to find some sore of "overlap" function i.e. </p>
  
  <pre><code>SELECT * FROM TABLE WHERE 'a,b,c' OVERLAP TABLE.LISTCOLUMN 
  </code></pre>
  
  <p>So, <code>LISTCOLUMN</code>contains any or all of a, b, or c </p>