title: Oracle select max id from table returns null value
body: <p>I have the query: </p>
  
  <pre><code>SELECT MAX(prod_id) FROM products;
  </code></pre>
  
  <p>It returns the maximum value if there are records. But, if I truncate table and run the same query I am unable to get the <code>max</code> id.</p>