sql - Oracle Random Number Generator Stored Procedure without using DBMS_RANDOM

Question

I don't have access to the DBMS_RANDOM package, so I would like to create my own stored procedure to generate random numbers in Oracle. Does anyone know how I might do that?

Thanks in advance!

EDIT: I am trying to generate a random row from each state. This is my code:

SELECT Z.* FROM ( 
      SELECT A.*, ROW_NUMBER() OVER (PARTITION BY A.STATE ORDER BY (
          select to_char(systimestamp,'ff') from dual)) AS ROW_ID 
        FROM   STATE_TABLE A ) Z WHERE Z.ROW_ID=1;

It gives me the same rows everytime I run it, but I want it to give me different rows everytime I run it. Help please?

Answer 1

If you want to select random rows from the table you can use SAMPLE clause

SELECT * FROM mytable SAMPLE(4);

This gives you randomly selected 4% of all rows.