title: Oracle: How to Right join a list of values in SQL
body: <p>I have a string such as </p>
  
  <p>String ids = "1,2,3,4";</p>
  
  <p>In Oracle database,
  Now I can do the select as </p>
  
  <pre><code>select a.name from a where id in (ids);
  </code></pre>
  
  <p>The result is if 1,2,4 exist in a table, then will show in list. If 4 not in table, it will not be showed.</p>
  
  <p>I want to do a right join such as </p>
  
  <pre><code>select a.name from a right join on a.id in (ids);
  </code></pre>
  
  <p>I hope the result can be </p>
  
  <pre><code>1's name
  2's name
  3's name
  null
  </code></pre>