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.
In the Table Details page, select the Explore Data tab
under Resources.
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.
Click the action menu corresponding to the row you wish to update, and select
Update Row.
Modify the values in Simple Input or Advanced JSON Input Updation Mode.
Click Update Row.
To view help for the current page, click the help link at the top of
the page.
Note:
If the table is a Global Active table, then updating the data in the local region
also updates it in all the regional replicas.
Deleting Table Data
Learn how to delete data in Oracle NoSQL Database Cloud Service tables from the NoSQL console.
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.
In the Table Details page, select the Explore Data tab
under Resources.
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.
Click the action menu corresponding to the row you wish to delete, and select Delete.
The Delete Row confirmation dialog opens.
Click Delete.
The row is deleted.
Note:
If the table is a Global Active table, then
deleting data in the local region also deletes the
data from all the regional replicas.