title: Oracle rand() function
body: <p>I tried to select a random data from table employees with query <code>rand()</code> but it can happen</p>
  
  <pre><code>SELECT email FROM employees
  ORDER BY RAND()
  LIMIT 1;
  </code></pre>
  
  <p>and the output is:</p>
  
  <blockquote>
    <p>ORA-00933: SQL command not properly ended<br>
    00933. 00000 -  "SQL command not properly ended"</p>
  </blockquote>
  
  <p>Can somebody tell me why??</p>