Table of Contents Table of Contents Title and Copyright Information Preface Conventions Used in This Book 1 Introduction to SQL for Oracle NoSQL Database Part I Introductory Examples 2 Simple SELECT Queries SQLBasicExamples Script Running the SQL Shell Choosing column data Substituting column names for a query Computing values for new columns Identifying tables and their columns Filtering results Ordering Results Limiting and Offsetting Results Using External Variables 3 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 4 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 5 Working With Indexes Basic Indexing Using Index Hints Complex Indexes Multi-Key Indexes Indexing JSON Data 6 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 Part II Language Definition 7 The SQL for Oracle NoSQL Database Data Model Example Data Data Types and Values Wildcard Types and JSON Data JSON Data Timestamp Timestamp Functions Type Hierarchy Subtype-Substitution Rule Exceptions SQL for Oracle NoSQL Database Sequences Sequence Concatenation Function 8 SQL for Oracle NoSQL Database Queries Select-From-Where (SFW) Expressions SELECT Clause SELECT Clause Hints FROM Clause WHERE Clause ORDER BY Clause Comparison Rules OFFSET Clause LIMIT Clause 9 Expressions Path Expressions Field Step Expressions Map Filter Step Expressions Array Filter Step Expressions Array Slice Step Expressions Constant Expressions Column Reference Expression Variable Reference Expression Searched Case Expressions Cast Expressions 10 Operators Logical Operators Value Comparison Operators Sequence Comparison Operators IS NULL Operator Exists Operator Is-Of-Type Operator 11 Constructors Array Constructors Map Constructors 12 Built-in Functions Time to Live Functions Time Functions 13 SQL UPDATE Statements Update Statement Syntax Update Clauses SET Clause ADD Clause PUT Clause REMOVE Clause SET TTL Clause A Introduction to the SQL for Oracle NoSQL Database Shell Running the shell Configuring the shell Shell Utility Commands connect consistency describe durability exit help history import load mode output page show faults show query show tables show users show roles timeout timer verbose version