DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Random Number Generator

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    Is there a random number generator in oracle that I could call from my programs?

  2. #2
    Join Date
    Jun 2001
    Posts
    316
    connect (as sys user)
    @dbmsoctk.sql
    @prvtoctk.plb
    @dbmsrand.sql

    exit

    Test the package in sql plus as a normal user
    SQL> execute dbms_random.initialize(123123);

    PL/SQL procedure successfully completed.

    SQL> select dbms_random.random from dual;

    RANDOM
    ---------
    997342005



    exec DBMS_RANDOM.TERMINATE;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width