title: splitting comma separated list into a temp table
body: <p>I want to convert the following IN query into inner join query :</p>
  
  <pre><code>select country, name, rank from table person_details 
     where country in ('india','USA','australia') 
     and   name in ('tom', 'jill', 'jack') 
     and   rank in ('first', 'third', 'fifith');
  </code></pre>
  
  <p>I have two questions: </p>
  
  <ol>
  <li><p>this table is big so will changing this IN query into inner join will speed up things.</p></li>
  <li><p>What will be best way to split this comma separated list to a column in some temp table. I have see many regex examples but they seem too complex and big.</p></li>
  </ol>
  
  <p>I am using Oracle 11g DB.</p>
  
  <p>Table snapshot : </p>
  
  <pre><code>Id   name   country   rank
   1    tom    india     first
   2    jill   USA      second
   3    jack   aus       first
  </code></pre>