title: Cast String to int and use in Where clause
body: <p>How to convert string field and use for Where clause.Am getting exception like this please help to find the wrong thing.</p>
  
  <pre><code>select * from student 
  where (cast (nvl(linerevnum,'0') as int)) = 1
  </code></pre>
  
  <p>linerevnum is varchar2</p>
  
  <p>Exception :
  invalid number</p>