Cryptography Stack Exchange is a question and answer site for software developers, mathematicians and others interested in cryptography. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?

share|improve this question
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. – D.W. Jan 15 '14 at 22:03
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. – 3asm_ Jan 15 '14 at 23:37
I removed the second part as indeed there is enough information. The first question concerns an Oracle product, so there is no source code. – 3asm_ Jan 15 '14 at 23:52
up vote 0 down vote accepted

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

-- Delayed Fibonacci, pilfered from Knuth volume 2
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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