select * from emp
offset 0 ROWS
fetch next
0.0000001 percent rows only ;
Does oracle internally round off the value to 1 row in case of percentage,untill or unless 0 is specified.
Note: emp is our standard Employee table with 14 rows.Please refer attachment for more clarity.
query_output.PNG (23.46 KB)