If I want that only x entries will be returned then I could use .limit(x) but for Oracle the syntax isn't correct. Using OracleQuery and .limit(2) ... Oracle SQL limit syntax is wrong #211. Copy link.

Question: is there a way to push down the "limit" clause to Oracle? For example, when I issue this statement in Postgres, select * from table limit 10;... the query I see in Oracle is "select col1, ...