select random rows from table
1001096Apr 4 2013 — edited Apr 4 2013Hi,
I want to delete 100 random rows from a table.
I saw this solution: http://stackoverflow.com/questions/848872/select-n-random-rows-from-sql-server-table
but it gives an error:
SQL> select top 10 percent * from employees;
ORA-00923: FROM keyword not found where expected
Does anybody know how to select random rows in pl sql?
thanks
Edited by: 998093 on 12:11 04/04/2013