How to issue correct paging query to get dataset from external database
I issue a sql like follow:
select *, %vid from (select * from order_info) where %vid between 1 and 10
I got error
[SQLCODE: <-400>:<Fatal error occurred>]
[%msg: <Remote JDBC error: ORA-00911: invalid character >]
So ,what's the correct paging syntax for query external data?