title: Order by case insensitive in oracle
body: <p>I want to order a following text in following order but, after trying the following query it is not working.</p>
  
  <p>values to order is "A", "B", "Y", "Z", "a", "b", "y", "z". </p>
  
  <p>Expected result "ZzYyBbAa"</p>
  
  <pre><code>SELECT COL FROM TABLE ORDER BY COL DESC;
  SELECT COL FROM TABLE ORDER BY UPPER/LOWER(COL) DESC; Result-&gt; ZzYybBaA
  SELECT COL FROM TABLE ORDER BY NLS_UPPER/NLS_LOWER(COL) DESC; Result-&gt; ZzYybBaA
  </code></pre>