SQL> select * from ta order by dbms_random.value();
A B C D E
---------- ---------- ---------- ---------- ----------
1 2 3 5 6
1 2 3 7 8
1 2 3 8 9
SQL> /
A B C D E
---------- ---------- ---------- ---------- ----------
1 2 3 7 8
1 2 3 5 6
1 2 3 8 9
SQL> /
A B C D E
---------- ---------- ---------- ---------- ----------
1 2 3 7 8
1 2 3 5 6
1 2 3 8 9
SQL> /
A B C D E
---------- ---------- ---------- ---------- ----------
1 2 3 7 8
1 2 3 8 9
1 2 3 5 6