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

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.
3. In the Table Details page, select the Explore Data 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. You may get an error that your statement is Incomplete or faulty. See Debugging SQL statement errors in the OCI console to learn about possible errors in the OCI console and how to fix them. See Developers Guide for SQL query examples.
5. Click Execute.
   The table data is displayed in the Records section.
6. To view the query execution plan of the SQL query that was executed, click Show query execution plan. The detailed query execution plan is displayed in a new window.

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

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.
3. In the Table Details page, select the Explore Data 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. You may get an error that your statement is Incomplete or faulty. See Debugging SQL statement errors in the OCI console to learn about possible errors in the OCI console and how to fix them. 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.