Oracle query fetch rows

[talks]

Can anybody suggest be the proper query for fetching number of rows in Oracle SQLPLUS?

I want to fetch row number x to y with other conditions.

I could not find a proper answer anywhere.