Table of Contents

• Title and Copyright Information
• Preface
  • Conventions Used in This Book
• 1 Introduction to SQL for Oracle NoSQL Database
• 2 Getting Started with SQL for Oracle NoSQL Database
  • Starting the SQL Shell
  • Basic SQL Statements
• 3 Working with Namespace
  • Managing Namespace
  • Namespace Resolution
  • Namespace Privileges and Authorization
• 4 Simple SELECT Queries
  • SQLBasicExamples Script
  • Choosing column data
  • Substituting column names for a query
  • Computing values for new columns
  • Identifying tables and their columns
  • Filtering Results
  • Grouping Results
  • Ordering Results
  • Limiting and Offsetting Results
  • Using External Variables
• 5 Working with complex data
  • SQLAdvancedExamples Script
  • Working with Timestamps
  • Working With Arrays
  • Working with Records
  • Using ORDER BY to Sort Results
  • Working With Maps
  • Using the size() Function
• 6 Working with JSON
  • SQLJSONExamples Script
  • Basic Queries
  • Using WHERE EXISTS with JSON
  • Seeking NULLS in Arrays
  • Examining Data Types JSON Columns
  • Using Map Steps with JSON Data
  • Casting Datatypes
  • Using Searched Case
• 7 Working with Expressions
  • Primary Expressions
  • Comparison Expressions
• 8 Working With GeoJSON Data
  • Geodetic Coordinates
  • GeoJSON Data Definitions
  • Searching GeoJSON Data
• 9 Working With Indexes
  • Basic Indexing
  • Using Index Hints
  • Complex Indexes
  • Multi-Key Indexes
  • Indexing JSON Data
  • Indexing JSON Collection Tables
  • Indexing Functions
  • Using Indexes
• 10 Working with Table Rows
  • Adding Table Rows using INSERT Statement
  • Adding Table Rows using UPSERT Statement
  • Modifying Table Rows using UPDATE Statements
    • Example Data
    • Changing Field Values
    • Modifying Array Values
      • Adding Elements to an Array
      • Changing an Existing Element in an Array
      • Removing Elements from Arrays
    • Modifying Map Values
      • Removing Elements from a Map
      • Adding Elements to a Map
      • Updating Existing Map Elements
    • Managing Time to Live Values
    • Avoiding the Read-Modify-Write Cycle
• 11 Working with Multi-Region Setup
  • Managing Regions
  • Using MR_COUNTERs
• 12 Built-in Functions
  • Timestamp Functions
  • Functions on Sequences
  • Function to generate a UUID string
  • Functions on Rows
  • Functions on GeoJson Data
  • Aggregate Functions
• 13 Working with JSON Collection Tables
• A Introduction to the SQL for Oracle NoSQL Database Shell
  • Running the SQL Shell
  • Configuring the shell
  • Shell Utility Commands
    • connect
    • consistency
    • describe
    • durability
    • exit
    • help
    • history
    • import
    • load
    • mode
    • output
    • page
    • show faults
    • show ddl
    • show indexes
    • show namespaces
    • show query
    • show regions
    • show roles
    • show tables
    • show users
    • timeout
    • timer
    • verbose
    • version