title: Compare two comma-separated columns in two different oracle tables
body: <p>I want to compare a comma-separated column in oracle table with another comma-separated column in a different table. If the all the values (within comma-separated column and irrespective of their order) on column one are contained within column two  it should not return that row.</p>
  
  <p>For example  - </p>
  
  <ol>
  <li><p>Column 1 has  a,b,c,def 
  Column 2 has  a,c,b</p>
  
  <p>This should not be returned as a,c and b in column 2 are contained
  within column 1 irrespective of their order.</p></li>
  <li><p>Column 1 has a,cl,owd 
  Column 2 has a,owd,pp</p>
  
  <p>This row should be returned because column 2 has 'pp' which is not
  contained within Column 1.</p></li>
  <li><p>Column 1 has vvv,ccc,rr
  Column 2 has ccc,rr</p>
  
  <p>This row should not be returned.</p></li>
  </ol>
  
  <p>Can I accomplish this in SQL ? Not expecting a procedure or function.</p>
  
  <p>Thanks for all the help !!</p>