Oracle PL/SQL for DBAs

Conclusion

Being able to generate random values is important in a variety of applications. Randomization is an integral part of encryption, but it plays a role in many other areas, as well. In this chapter, I showed how to generate all types of random numbers and strings of different precisions and lengths, how to control randomness using the proper seeding techniques, and how to avoid the risk of generating non-random values by resetting the seed to the same value. To make the generation better approximate real-world values, I also discussed how to create random values that follow certain statistical patterns and, finally, how to verify the randomness of the data generated.