Oracle 11.2 OFFSET FETCH gives error

[niphadkarneha]

Describe the bug
I am using Oracle 11.2 database. When I run a query to fetch a list of account numbers for e.g.

SELECT
  account_number
FROM
  dummy.table FETCH NEXT 10000 ROWS ONLY

It throws an error of, "Error: ORA-00933: SQL command not properly ended".
Adding a ' ; ' does not make any difference. The problem lies in the FETCH NEXT command which is auto-generated by Cubejs which is incompatible with Oracle 11.2.

stackoverflow Issue

Expected behavior
Simple list of account numbers in a single column.

Version:

• Oracle version: 11.2
• node [node -v] 12.16.1
• npm [npm -v] 6.13.4

Additional context
I'd be happy to provide any/all/more details.

[paveltiunov]

@niphadkarneha Hey Neha! Thanks for posting this! I can confirm this syntax is available since version 12.

[malakiasz]

Hello ,i have same problem with Oracle 11 g ( schema not generate correctly query for Oracle 11g)
U have A solutions for this ?
Thanx

[igorlukanin]

For the record, the solution to this should be similar to what is outlined in this comment: #191 (comment)