Previous Next JavaScript must be enabled to correctly display this content

## 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
    - SET Clause
    - ADD Clause
    - PUT Clause
    - REMOVE Clause
    - SET TTL Clause
  - 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