node-oracledb/examples/README.md

802 B

Node-oracledb Examples

This directory contains node-oracledb examples.

To run the examples:

  • Install node-oracledb.

  • Use demo.sql to create schema objects used by the samples. For example, to load them in the HR schema run:

    sqlplus hr/welcome@localhost/orclpdb @demo.sql
    
  • Edit dbconfig.js and set your username, password and the database connection string:

    module.exports = {
        user: "hr",
        password: "welcome",
        connectString:"localhost/orclpdb"
    };
    
    
  • Then run the samples like:

    node select1.js
    

The demonstration objects can be dropped with demodrop.sql:

sqlplus hr/welcome@localhost/orclpdb @demodrop.sql