Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_RANDOM , 2 of 5


INITIALIZE Procedure

To use the package, first call the initialize subprogram with the seed to use.

Syntax

DBMS_RANDOM.INITIALIZE (
   seed  IN  BINARY_INTEGER);


Note:

Use a seed that is sufficiently large, more than 5 digits. A single digit might not return sufficiently random numbers. Also consider getting the seed from variable values such as the time.  


Parameters

Table 43-2 INITIALIZE Procedure Parameters
Parameter  Description 
seed
 

Seed number used to generate a random number. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback