title: how to sort by case insensitive alphabetical order using COLLATE NOCASE
body: <p>I am trying to sort alphabetically case insensitive using <code>COLLATE NOCASE</code>
  but getting error </p>
  
  <blockquote>
    <p>ORA - 00933 SQL command not properly ended.</p>
  </blockquote>
  
  <p>below is the query I am firing:</p>
  
  <pre><code>SELECT LPN.LPN_ID, 
         LPN.TC_ORDER_ID, 
         ORDERS.D_NAME, 
         ORDERS.PURCHASE_ORDER_NUMBER AS ORDER_PURCHASE_ORDER_NUMBER, 
         ORDERS.D_NAME AS D_NAME_2, LPN.LPN_NBR_X_OF_Y 
    FROM ORDERS ORDERS, 
         LPN LPN 
   WHERE ORDERS.ORDER_ID=LPN.ORDER_ID 
   ORDER BY ORDERS.D_NAME COLLATE NOCASE DESC
  </code></pre>
  
  <p>I checked here to try this but still getting error
  <a href="https://stackoverflow.com/questions/2413427/how-to-use-sql-order-by-statement-to-sort-results-case-insensitive">How to use SQL Order By statement to sort results case insensitive?</a>
  Any suggestions please ?        </p>