title: Search comma separated value in oracle 12
body: <p>I have a Table - <code>Product</code> In Oracle, wherein <code>p_spc_cat_id</code> is stored as comma separated values.</p>
  
  <pre><code>p_id p_name p_desc p_spc_cat_id
  1    AA     AAAA   26,119,27,15,18
  2    BB     BBBB   0,0,27,56,57,4
  3    BB     CCCC   26,0,0,15,3,8
  4    CC     DDDD   26,0,27,7,14,10
  5    CC     EEEE   26,119,0,48,75
  </code></pre>
  
  <p>Now I want to search <code>p_name</code> which have <code>p_spc_cat_id</code> in <code>'26,119,7'</code> And this search value are not fixed it will some time <code>'7,27,8'</code>. The search text combination change every time </p>
  
  <p>my query is:</p>
  
  <pre><code>select p_id,p_name from product where p_spc_cat_id in('26,119,7');
  </code></pre>
  
  <p>when i execute this query that time i can't find any result  </p>