title: ORA-01722 invalid number error with oracle database in hibernate query language
body: <p>I am using query</p>
  
  <pre><code>select x 
  from table1 x 
  order by x.it desc
  </code></pre>
  
  <p>It is working good when I use it with Postgres but whenever i change the database and start to use oracle it is throwing an error that is,</p>
  
  <blockquote>
    <p>ERROR -- ORA-01722: invalid number<br>
    org.hibernate.exception.SQLGrammarException: could not execute query</p>
  </blockquote>