Declares a random variable of type RndExpN. With each access, such a variable contains a random integer value that is generated following an exponential distribution. The floating-point values of the exponential distribution are rounded to integer values (1.5 —>—> 2, 1.4 —>—> 1, ...).
RndExpN( l..u: m ): number;
number
Parameter | Description |
---|---|
l | Lower boundary of the integer interval of random values (number) |
u | Upper boundary of the integer interval of random values (number) |
m |
Mean value of the exponential distribution (float) Condition: l <= m <= u |
If a generated random value is outside the interval of integer values declared, it is replaced by the value of the respective boundary.
dclrand rEvent1, rEvent2 : RndBin(0.25); rTime1 : RndExpF(5.5); rTime2 : RndUniF(0.5..12.5); rCube : RndUniN(1..6); rPrice : RndUniN(10..2000); rArtNo : RndExpN(1..10000: 100.0); ... dclsql UpdArticle: UPDATE article SET price = :rPrice WHERE articlenumber = :rArtNo;
The random variable rArtNo is used in a SQL command to access an article with a random article number of type integer. The generated random integer values follow an exponential distribution with a mean value of 100.0. Values outside the interval 1 to 10000 are replaced by the respective boundary of the interval.
OraSample.bdf, DBApi01.bdf