title: Oracle, Select rows from table where column value is in some range
body: <p>I have a Oracle table, where along with other columns there is an column named ERROR_CODE VARCHAR2. The values can be in the range 7000-7999 or 3000-3999. For eg if my ERROR_CODE column has the following values</p>
  
  <pre><code>ERROR_CODE
  
  4567
  7543
  7001
  6999
  8000
  </code></pre>
  
  <p>How can i fetch all records which has the ERROR_CODE in the range say 7000-7999. Something like the Between clause. The output of my query should give </p>
  
  <p>ERROR_CODE</p>
  
  <pre><code>7543
  7001
  </code></pre>
  
  <p>Hope its clear. Thanks for any help</p>