Managing Table Data Using Console

Learn how to view and download Oracle NoSQL Database Cloud Service table data using Console.

This article has the following topics:

Viewing Table Data

Learn how to view data in Oracle NoSQL Database Cloud Service tables from the NoSQL console.

To view table data:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console.
  2. The NoSQL console lists all the tables in the tenancy. To view table details, do either of the following:
    • Click the table name, or
    • Click the action menu corresponding to the table name and select View Details.
    The Table Details page opens up.
  3. In the Table Details page, select the Table Rows tab under Resources.
  4. By default, the query text is populated with a SQL query that will retrieve all the records from the table. You can modify this query with any valid SQL for Oracle NoSQL statement. See Developers Guide for SQL query examples.
  5. Click Run Query.
    The table data is displayed in the Records section.

Downloading Table Data

Learn how to download data in Oracle NoSQL Database Cloud Service tables from the NoSQL console.

To download table data:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console.
  2. The NoSQL console lists all the tables in the tenancy. To view table details, do either of the following:
    • Click the table name, or
    • Click the action menu corresponding to the table name and select View Details.
    The Table Details page opens up.
  3. In the Table Details page, select the Table Rows tab under Resources.
  4. By default, the query text is populated with a SQL query that will retrieve all the records from the table. You can modify this query with any valid SQL for Oracle NoSQL statement. See Developers Guide for SQL query examples.
  5. Click the action menu corresponding to the row you wish to download, and select Download JSON.
    The row downloads in JSON format.