You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for DBMS_RANDOM


1 to 20 of 43 results. Previous page Prev  Next next page
Results per page:   20  | 40


Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

66 DBMS_RANDOMThe 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

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Using DBMS_RANDOMSecurity Model Operational Notes

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Summary of DBMS_RANDOM SubprogramsTable 66-1  DBMS_RANDOM Package Subprograms Subprogram Description INITIALIZE Procedure Initializes

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

PragmasPRAGMA restrict_references (initialize, WNDS)

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

ParametersTable 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.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

STRING FunctionThis function gets a random string.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

SyntaxDBMS_RANDOM.NORMAL RETURN NUMBER;

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

RANDOM ProcedureThis procedure generates a random number (but see Usage Notes ).

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

ParametersTable 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.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Security ModelThis 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.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

SyntaxDBMS_RANDOM.RANDOM RETURN binary_integer;

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

SyntaxDBMS_RANDOM.INITIALIZE ( val IN BINARY_INTEGER);

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Return ValuesTable 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).

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

TERMINATE ProcedureWhen you are finished with the package, call the TERMINATE procedure (but see Usage Notes )

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

INITIALIZE ProcedureThis procedure initializes the generator (but see Usage Notes ).

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Return ValuesTable 66-9 VALUE Function Parameters Parameter Description NUMBER Returns an Oracle Number.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Usage NotesThis procedure is obsolete as it simply calls the SEED Procedures.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

Return ValuesTable 66-3 NORMAL Procedure Parameters Parameter Description number Returns a random number.

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

SyntaxDBMS_RANDOM.SEED ( seed IN BINARY_INTEGER); DBMS_RANDOM.SEED ( seed IN VARCHAR2);

Packages and Types Reference, 10g Release 1 (10.1)

66 DBMS_RANDOM

PragmasPRAGMA restrict_references (seed, WNDS);