Oracle DBMS offer builtin random number generator (pseudo to be accurate). DBMS_RANDOM is one of the available packages, it is however considered as insecure for cryptography. Do we happen to know the algorithm used by this method ?

  • 1
    $\begingroup$ What research have you done? There's lots written in textbooks and on the Internet (and on this site) about the criteria for a PRNG to be fit for cryptography. Also, please, one question per question; you've crammed two different questions into one post. $\endgroup$ – D.W. Jan 15 '14 at 22:03
  • $\begingroup$ My research on the DBMS_RANDOM didn't yield any information about the used algorithm. If I've missed something, I'd be grateful if you can point it out. $\endgroup$ – 3asm_ Jan 15 '14 at 23:37
  • $\begingroup$ I removed the second part as indeed there is enough information. The first question concerns an Oracle product, so there is no source code. $\endgroup$ – 3asm_ Jan 15 '14 at 23:52

A quick Google search shows the source code is available in the file dbmsrand.sql, which says:

-- Delayed Fibonacci, pilfered from Knuth volume 2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.