Search notes:

ORA-30577: SAMPLE group size must be in the range [1,UB4MAXVAL]

OK:
select * from dual sample (50, 1);
Not OK:
select * from dual sample (50, 0);

See also

Other Oracle error messages such as ORA-30562: invalid SAMPLE percentage

Index