What "row reduction clauses" does Oracle support? (for Excel Power Query)

Question

I want to add an Oracle table as a data source in Excel 2016 Power Query (via ODBC):

---

At the bottom of the ODBC dialog, there is an option to specify the "Supported row reduction clauses (optional)":

---

Question:

What option applies to Oracle 18c?

1. (None)
2. TOP
3. LIMIT and OFFSET
4. LIMIT
5. ANSI SQL-compatible

Answer 1

Oracle supports

OFFSET n ROWS

and

FETCH FIRST|NEXT n ROWS ONLY
or
FETCH FIRST|NEXT n ROWS WITH TIES

Docs here - see "row_limiting_clause"