Use Oracle NoSQL database connector to browse tables and run queries against the Oracle NoSQL Database Cloud Service, Oracle NoSQL Database on-premises or to the Oracle NoSQL Cloud Simulator.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Click the Oracle NoSQL DB view in the Activity Bar.
Click Add Connection to open the Oracle NoSQL DB Show Connection Settings page.
In the Connection Settings page, click Cloud, Onprem or CloudSim to connect to Oracle NoSQL Database Cloud Service, Oracle NoSQL Database (Onprem) or Oracle NoSQL Database Cloud Simulator.
Enter the connection information and connect.
Manage Tables
Once you connect to your deployment -
Use the Table Explorer left navigation to explore your tables.
Click the table name to view its columns, indexes, primary key(s), and shard key(s). The column name displays along with its data type.
You can refresh the schema or table at any time to re-query your deployment and populate Oracle NoSQL Database with the most up-to-date data.
In the Table Explorer, locate the connection and click the Refresh icon to reload the schema. Alternatively, you can right-click the connection and select Refresh Schema.
In the Table Explorer, locate the table name and click the Refresh icon to reload the table. Alternatively, you can right-click the table name and select Refresh Table.
Create New Tables
To create a new table:
Hover over the database where you want to add the new table.
Click the Plus icon that appears.
In the prompt, enter the details for your new table.
You can create the Oracle NoSQL Database table in two modes:
Simple DDL Input : You can use this mode to create the table declaratively, that is, without writing a DDL statement.
Advanced DDL Input : You can use this mode to create the table using a DDL statement.
(Optional) Click Show DDL to view the DDL statement formed based on the values entered in the fields in the Simple DDL input mode. This DDL statement gets executed when you click Create.
Click Create.
Execute SQL Queries and DML Statements for a Table
Right-click the target table and select Browse Table.
In the SQL window, specify the SELECT query in the text box and click . The query result is displayed in tabular format. You can adjust the number of rows per page.
To view individual cell data separately, click the table cell.
You can also execute DML statements to update, insert, and delete data from a table.
SDK
This extension uses Oracle NoSQL Node.js SDK which is included in VSIX package under '/oracle-nosqldb' directory. This directory includes a separate README and CHANGELOG file specific to the SDK.