48
DBMS_RANDOM

The DBMS_RANDOM package provides a built-in random number generator. It is faster than generators written in PL/SQL because it calls Oracle's internal random number generator.

This chapter discusses the following topics:

• Requirements
• Summary of DBMS_RANDOM Subprograms

Requirements

DBMS_RANDOM must be initialized before calling the random number generator. The generator produces 8-digit integers. If the initialization subprogram is not called, then the package raises an exception.