7 Data Row Management
This chapter describes data rows and inserting and managing data rows in Oracle NoSQL Database.
This chapter contains the following topics:
- INSERT Statement
- Inserting Rows into JSON Collection Tables
- Inserting Rows with an IDENTITY Column
- Inserting rows into a table with a UUID column
- Inserting rows with an MR_COUNTER column
- Upsert statement
- Updating rows of a table with a UUID column
- DELETE Statement
- UPDATE Statement
- Update Clauses
- Updating rows with an IDENTITY Column
- Updating rows with an MR_COUNTER column
- Example: Updating Rows
- Example: Updating JSON Data
- Example: Updating JSON collection tables
- Example: Updating TTL
- Example: Updating IDENTITY defined as GENERATED ALWAYS
- Example: Updating IDENTITY defined as GENERATED BY DEFAULT
- JSON Collection Table Example