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 with an IDENTITY Column
• Inserting rows into a table with a UUID column
• Inserting rows with an MR_COUNTER column
• DELETE Statement
• UPDATE Statement
• Update Clauses
  • SET Clause
  • ADD Clause
  • PUT Clause
  • REMOVE Clause
  • SET TTL Clause
• Updating rows with an IDENTITY Column
• Example: Updating Rows
• Example: Updating JSON Data
• Example: Updating TTL
• Example: Updating IDENTITY defined as GENERATED ALWAYS
• Example: Updating IDENTITY defined as GENERATED BY DEFAULT
• Updating rows of a table with a UUID column
• Updating rows with an MR_COUNTER column