title: return null if no rows found oracle query with IN clause
body: <p>I have a table with three columns.
  I query that table with IN clause. </p>
  
  <p>select column1 from table1 where column1 in (1,2,3) order by column2, column3</p>
  
  <p>The table1 contains only values 1 and 2 in column1. I want to return the not available value also in my result, and that should be sorted in the bottom.</p>
  
  <p>example data</p>
  
  <p>column1 column 2 column 3</p>
  
  <pre><code>1   100 11
  
  2   101 50
  </code></pre>
  
  <p>output, the not available values should be in the last.</p>
  
  <p>column1 column 2 column 3</p>
  
  <pre><code>1   100 11
  
  2   101 50
  
  3 null null
  </code></pre>
  
  <p>I tried with subquery with NVL, like select nvl((select.. in(1,2,3)),null) from dual, due to IN Clause, I am getting single row subquery returns more than one row issue, which is expected.</p>
  
  <p>Also tried with the union but nothing works. Great if any help. Thanks</p>