/* This SQL will a select a set of 6 random numbers every time it is run. The numbers will be between 1 and 49 */ select r from ( select r from ( select rownum r from al_objects where rownum < 50 ) order by dbms_random.value ) where rownum <= 6;
How to select set of 6 random numbers every time