NORMAL function

The NORMAL function returns a random number in a standard normal distribution.

The function returns a DECFLOAT value.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_RANDOM.NORMAL()
Note: Calling NORMAL before seeding the random number generator explicitly by calling SEED, SEED_STRING, or INITIALIZE defaults to using a seed that is based on the system current timestamp.