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