No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
 

Quick Start: Developing Node.js Applications for Oracle Database

This tutorial shows you how to connect Node.js applications to Oracle Database using the node-oracledb module. This module lets you quickly develop applications that execute SQL or PL/SQL statements. Your applications can also use Oracle's document storage SODA calls. Node-oracledb can be used with TypeScript or directly with Node.js.

The steps below show connecting to an on-premise database, but if you would like to use an Oracle Autonomous Database in Oracle Cloud instead (for example from the Always Free service), then see the Developing Node.js Applications for Oracle Autonomous Database tutorial.

    Node.js node-oracledb on Windows

    Open all Close all

  • 1. Install Oracle Database

    • If you do not already have access to an Oracle Database, then download and install Oracle Database XE following these instructions.

      More resources:

      Video showing how to install Oracle Database XE on Windows and conduct basic administration.

      Oracle Database XE Installation Guide for Windows

    • Alternatively, if you already have a database but it is on a remote computer, then install the Oracle Instant Client "Basic" and "SQL*Plus" packages from here. Remember to install the VS Redistributable and add the directory to your PATH environment variable, as instructed. You will need to know the connect string for the database, and substitute it in the instructions below.

    • Alternatively, if you would like to use an Oracle Autonomous Database in Oracle Cloud instead (for example from the Always Free service), then see the Developing Node.js Applications for Oracle Autonomous Database tutorial.

  • 2. Create a Database User

  • 3. Install Node.js

  • 4. Install node-oracledb

  • 5. Create a Node.js Application

  • 6. Run the Node.js Application

    In a terminal window, run the app:

    Copied to Clipboard
    Error: Could not Copy
    node example.js

    You should see a message that you connected to the database, five rows were inserted, and the task list with each task's completion status returned to the terminal window. Congratulations! You have successfully queried the Oracle Database.

More information and resources on using node-oracledb are available here.

    Node.js node-oracledb on macOS (Intel x86)

    Open all Close all

  • 1. Install Oracle Database

    If you do not already have access to an Oracle Database, you can easily install one using VirtualBox. (There is no native macOS port of Oracle Database). If you would like to use an Oracle Autonomous Database in Oracle Cloud instead (for example from the Always Free service), then see the Developing Node.js Applications for Oracle Autonomous Database tutorial.

    To install Oracle Database XE, follow the instructions here. In summary:

    • Install Oracle VM VirtualBox for "OS X hosts"

    • Install Vagrant

    • Download and unzip the Oracle Database 18c XE Vagrant configuration ZIP file, or use git to clone the GitHub repository. Open a terminal window and change to the OracleDatabase/18.4.0-XE directory, then run vagrant up

      At the conclusion, the database will be running. The confirmation message will display the password for the privileged accounts.

  • 2. Install the Oracle Instant Client Basic and SQL*Plus Packages

  • 3. Create a Database User

  • 4. Install Node.js

  • 5. Install node-oracledb

  • 6. Create a Node.js Application

  • 7. Run the Node.js Application

    In a terminal window, run the app:
    Copied to Clipboard
    Error: Could not Copy
    node example.js

    You should see a message that you connected to the database, five rows were inserted, and the task list with each task's completion status returned to the terminal window. Congratulations! You have successfully queried the Oracle Database.

More information and resources on using node-oracledb are available here.

    Node.js node-oracledb on Linux

    Open all Close all

  • 1. Install Oracle Database

  • 2. Create a Database User

  • 3. Install Node.js

  • 4. Install node-oracledb

  • 5. Create a Node.js Application

  • 6. Run the Node.js Application

More information and resources on using node-oracledb are available here.