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