title: Random Number Generator in oracle 11g by SQL or Stored procedure without DBMS.RANDOM
body: <p>I want to generate random Numbers in Oracle 11g. But due to client request, I cannot use <code>dbms_random.random</code> of Oracle.</p>
  
  <p>Is there any other way I can generate random numbers?</p>
  
  <p>Duplication are strictly not allowed, numbers should be of length 4 </p>
  
  <pre><code>0001
  0053
  9871
  0098
  0003
  </code></pre>
  
  <p>If any other Oracle library from which I can generate, then suggestions would be appreciated :)</p>