Oracle CRUD

Owned by Dheeraj Kumar Aggarwal
Last updated: May 03, 2017
2 min read

In this post, we will look at, how we can perform CRUD operation on Oracle Database.

Assumptions:

  1. vutil is installed.
  2. Oracle connection is configured in the config.json file in vutil directory.

  3. NodeJS `oracledb` driver is installed in the vutil directory. To install the driver, execute the following commands:

    $ cd <PATH_TO_VUTIL_DIRECTORY>
$ npm install oracledb

Now, follow the below process to execute query on oracledb via REST API.

First create a test case which will fire a HTTP request on vutil server to validate the database state:

CRUD Operations:

  1. Insert Query
    Insert query can be specified as shown in the following screenshot:
     
  2. Select Query
    Select query can be specified as shown in the following screenshot:
  3. Update Query
    Update query can be specified as shown in the following screenshot: 
     
  4. Delete Query
    Delete query can be specified as shown in the following screenshot: