2 About Oracle NoSQL Database Visual Studio Code Extension

The Oracle NoSQL Database provides an extension for Microsoft Visual Studio Code which lets you connect to a running instance of Oracle NoSQL Database.

You can use Oracle NoSQL Database Visual Studio (VS) Code extension to:

• View the tables in a well-defined tree structure with Table Explorer.
• View information on columns, indexes, primary key(s), and shard key(s) for a table.
• View column data in a well-formatted JSON Structure.
• Create tables and child tables using form-based schema entry or supply DDL statements.
• Create JSON Collection tables using Advanced DDL Input mode and insert, update rows using Advanced JSON Input mode.
• Drop tables, columns, rows, or indexes.
• Add new columns and indexes using form-based entry or supply DDL statements.
• Add new rows using a form-based entry or use Advanced JSON Input mode.
• Run SELECT SQL queries on a table and view query results in tabular format.
• Run DDL statements to manage regions, namespaces, and roles.
• Run DML statements to update, insert, and delete data from a table.
• Calculate recommended cache and storage settings by using the JeCacheSizingTool.
• Download SELECT query results as a JSON file or as individual JSON files per row.
• Use Prettify SQL to improve readability.