How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
66 DBMS_RANDOM → The DBMS_RANDOM package provides a built-in random number generator. DBMS_RANDOM is not intended … for cryptography. This chapter contains the following topics: Using DBMS_RANDOM Security Model Operational Notes Summary of DBMS_RANDOM Subprograms
Using DBMS_RANDOM → Security Model Operational Notes
Summary of DBMS_RANDOM Subprograms → Table 66-1 DBMS_RANDOM Package Subprograms Subprogram Description INITIALIZE Procedure Initializes
Pragmas → PRAGMA restrict_references (initialize, WNDS)
Parameters → Table 66-8 VALUE Function Parameters Parameter Description low The lowest number in a range from which to generate a random number. The number generated may be equal to low. high The highest number below which to generate a random number. The number generated will be less than high.
STRING Function → This function gets a random string.
Syntax → DBMS_RANDOM.NORMAL RETURN NUMBER;
RANDOM Procedure → This procedure generates a random number (but see Usage Notes ).
Parameters → Table 66-6 STRING Function Parameters Parameter Description opt Specifies what the returning string looks like: 'u', 'U' - returning string in uppercase alpha characters 'l', 'L' - returning string in lowercase alpha characters 'a', 'A' - returning string in mixed case alpha characters 'x', 'X' - returning string in uppercase alpha-numeric characters 'p', 'P' - returning string in any printable characters.
Security Model → This package should be installed as SYS. By default, the package is initialized with the current user name, current time down to the second, and the current session.
Syntax → DBMS_RANDOM.RANDOM RETURN binary_integer;
Syntax → DBMS_RANDOM.INITIALIZE ( val IN BINARY_INTEGER);
Return Values → Table 66-4 RANDOM Procedure Parameters Parameter Description binary_integer Returns a random integer greater or equal to -power(2,31) and less than power(2,31).
TERMINATE Procedure → When you are finished with the package, call the TERMINATE procedure (but see Usage Notes )
INITIALIZE Procedure → This procedure initializes the generator (but see Usage Notes ).
Return Values → Table 66-9 VALUE Function Parameters Parameter Description NUMBER Returns an Oracle Number.
Usage Notes → This procedure is obsolete as it simply calls the SEED Procedures.
Return Values → Table 66-3 NORMAL Procedure Parameters Parameter Description number Returns a random number.
Syntax → DBMS_RANDOM.SEED ( seed IN BINARY_INTEGER); DBMS_RANDOM.SEED ( seed IN VARCHAR2);