node-oracledb/examples
Christopher Jones 4ca97f5d38 Review sample password usage 2019-02-08 12:55:21 +11:00
..
README.md Review sample password usage 2019-02-08 12:55:21 +11:00
blobhttp.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
calltimeout.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
clobexample.txt Move more links to http://oracle.github.io/node-oracledb/ 2018-03-27 16:12:28 +11:00
connect.js Add connectionpool.js example 2018-11-26 15:01:33 +11:00
connectionpool.js Cross reference the session fixup example 2019-01-24 10:52:48 +11:00
cqn1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
cqn2.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
date.js Show ORA_SDTZ in examples 2019-01-11 08:55:31 +11:00
dbconfig.js Review sample password usage 2019-02-08 12:55:21 +11:00
dbmsoutputgetline.js Sync examples with master and update for v2 2017-06-14 11:23:10 +10:00
dbmsoutputpipe.js Fix lint warnings/whitespace/formatting of some examples 2017-10-23 13:12:26 +11:00
demo.sql Drop demo table for idempotency 2018-06-27 16:53:55 +10:00
demodrop.sql Add Continuous Query Notification (CQN) support 2018-05-30 11:18:42 +10:00
dmlrupd1.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
dmlrupd2.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
em_batcherrors.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_batcherrors_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_dmlreturn1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_dmlreturn1_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_dmlreturn2.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_dmlreturn2_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_insert1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_insert1_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_insert2.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_insert2_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_plsql.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_plsql_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_rowcounts.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
em_rowcounts_aa.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
endtoend.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
example.js Show ORA_SDTZ in examples 2019-01-11 08:55:31 +11:00
fetchinfo.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
fuzzydinosaur.jpg Update examples for node-oracledb 1.0 2015-08-17 16:03:41 +10:00
insert1.js Advertise executeMany() 2018-08-22 13:24:13 +10:00
insert2.js Improve wording (see #993) 2018-11-15 16:12:42 +11:00
lobbinds.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobinsert1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobinsert2.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobinserttemp.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobplsqltemp.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobselect.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobstream1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
lobstream2.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
metadata.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
plsqlarray.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
plsqlfunc.js Mention PL/SQL named param syntax. See issue #420 2018-03-27 16:29:08 +11:00
plsqlproc.js Mention PL/SQL named param syntax. See issue #420 2018-03-27 16:29:08 +11:00
promises.js Sync examples with master and update for v2 2017-06-14 11:23:10 +10:00
raw1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
refcursor.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
refcursortoquerystream.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
resultset1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
resultset2.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
resultsettoquerystream.js Typos: too many n's in connection 2019-01-09 13:23:17 +11:00
rowlimit.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
select1.js Add connectionpool.js example 2018-11-26 15:01:33 +11:00
select2.js Standardize some example syntax 2018-03-27 16:04:27 +11:00
selectjson.js Use new documentation version-independent links 2018-08-22 13:14:25 +10:00
selectjsonblob.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
selectstream.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
sessionfixup.js Fix callback API to match latest design 2019-01-11 08:57:10 +11:00
sessiontagging1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
sessiontagging2.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
soda1.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
version.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
webapp.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
webappawait.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00
webapppromises.js Add required node-oracledb version to examples 2019-01-11 08:54:26 +11:00

README.md

Node-oracledb Examples

This directory contains node-oracledb examples.

To run the examples:

  • Install node-oracledb.

  • Edit dbconfig.js and set your username, password and the database connection string:

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

    node example.js
    
  • Some example require schema objects created by demo.sql. For example, to load them in the HR schema run:

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

    The demonstration objects can be dropped with demodrop.sql:

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