var connectData = {
    hostname: "myhost",
    port: 1521,
    database: "mydb", // System ID (SID)
    user: "usertest",
    password: "mypass"
}
oracle.connect(connectData, function(err, connection) {
    if (err) { console.log("Error connecting to db:", err); return; }

    connection.execute("SELECT * FROM <table_name>", [], function(err, results) {

        if (err) { console.log("Error executing query:", err); return; }

        console.log(results); //This statement's not working
        connection.close(); // call only when query is finished executing
    });

});