title: Oracle order by via JPA with numeric first
body: <p>I have column data like this in my db </p>
  
  <pre><code>data 
  -----
  1
  2
  A
  3
  4
  B
  </code></pre>
  
  <p>I have below nls settings in place </p>
  
  <pre><code>SELECT * From NLS_SESSION_PARAMETERS;
  NLS_LANGUAGE    AMERICAN
  NLS_TERRITORY    AMERICA
  NLS_CURRENCY    $
  NLS_ISO_CURRENCY    AMERICA
  NLS_ISO_CURRENCY    AMERICA
  NLS_NUMERIC_CHARACTERS    .,
  NLS_CALENDAR    GREGORIAN
  NLS_DATE_FORMAT    DD-MON-RR
  NLS_DATE_LANGUAGE    AMERICAN
  NLS_SORT    BINARY
  NLS_COMP    BINARY
  </code></pre>
  
  <p>When I query the db for <code>**select data from &lt;mytable&gt; order by data **</code> I am getting the result as below</p>
  
  <pre><code>data
  -----
  1
  2
  3
  4
  A
  B
  </code></pre>
  
  <p>The same query via hibernate is giving the results with alphabets first and numeric later</p>
  
  <pre><code>data
  -----
  A
  B
  1
  2
  3
  4
  </code></pre>
  
  <p>But, I want column to be displayed with numbers first and alphabets later via hibernate</p>
  
  <pre><code>data
  ------
  1
  2
  3
  4
  A
  B
  </code></pre>
  
  <p>Can someone help me with this.</p>