I am making a query and trying to fetch a random number of rows from a database but Oracle keeps telling me my command has not been ended properly.
order by random_column_name
offset 0 rows
fetch first 10 rows only
That syntax isn't valid until Oracle Database 12c.
You would say instead
select * from random_table order by random_col where rownum < 11