node.js – Nodejs oracledb different result with query executer and direct query from DBMS

When I execute my oracle query from the DBMS it returns correct data. But when i run the same query from from the nodejs oracledb code, results are wrong. I’ve searched this everywhere. but didn’t get any solution. please help me. oracledb version is 5.3.0. I’ve also mentioned my query below. SELECT ordersl3.* FROM ( … Read more