Name
SEED
Synopsis
This program initializes the DBMS_RANDOM package with a user-specified “seed” that will be used to generate random values. Having a different seed value for different programs ensures the generation of sufficiently random values. SEED is overloaded: both versions are functions, each accepting a parameter of a different datatype.
Function—Version 1
Accepts a single parameter, val, which will be used as the seed value. The parameter is a VARCHAR2 value, which may be up to 2,000 bytes.
Function—Version 2
Accepts a single parameter, val, which will be used as the seed value. The parameter is a BINARY_INTEGER value.
Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
