Oracle ORA-00933：SQL命令未正确结束

Question

I try to use golang and query data from Oracle. My SQL query is:

SELECT * FROM TABLE1 OFFSET 10 ROWS;

But it gives an error:

EXTRA *errors.withStack=dpiStmt_execute: ORA-00933: SQL command not properly ended

My SQL query works fine when I query in SQL*Plus, but errors when I use golang.

Answer 1

If the offset is not specified, it is assumed that it is 0 (zero). So, remove that clause (as it does nothing in your case), i.e.

select * from table1

and use that query in golang.