node-oracle - node.js查询操作oracle数据库返回数据只有前100条？

Question

数据库有3149条数据

node只读去了前一百条？求帮助怎么解决

Answer 1

Without using the ResultSet, the default maximum number of query results for nodejs to query the Oracle database is 100. If you want to see more, you must set it yourself:
var oracledb = require('oracledb ');
oracledb.maxRows = 50000;
If you use ResultSet, there is no need to set maxRows, and all data can be automatically queried. For specific usage, please refer to the official documentation.
https://github.com/oracle/node-oracledb/blob/master/doc/api.md