Table of Contents
- Title and Copyright Information
- 1 Introduction to SQL for Oracle NoSQL Database
- 2 Oracle NoSQL Database Data Model
- 3 Namespace Management
- 4 Region Management
-
5
Table Management
- CREATE TABLE Statement
- SHOW TABLES Statement
- DESCRIBE TABLE Statement
- Table Hierarchies
- Using JSON Collection Tables
- Using the IDENTITY Column
- Using the UUID data type
- Using the MR_COUNTER datatype
- Sequence Generator
- DROP TABLE Statement
- ALTER TABLE Statement
- Altering an IDENTITY Column
- Add or Remove a UUID column
- Add or Remove an IDENTITY column
- Add or Remove an MR_COUNTER column
- 6 SQL Query Management
-
7
Data Row Management
- 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
- 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
- 8 Indexes
- 9 Query Optimization
-
10
Query Plan
- Overview of a query plan
-
Examples of query execution plan
- Example 1 : Using a covering index in a query plan with only index scans
- Example 2 : Using a covering index in a query plan with index scans and index predicates
- Example 3: Using a non-covering index in a query plan with index scans
- Example 4: Sort the data using a Covering index
- Example 5: Sort the data using a field not part of the index
- Example 6: Group the data using a Covering index
- Example 7: Group data with fields not part of the index
- 11 GeoJson Data Management
-
12
Built-in Functions
- Functions on Complex Values
- Functions on Sequences
- Functions on Timestamps
- Function to generate a UUID string
- Functions on Rows
- Functions on GeoJson Data
- Functions on Strings
- Function to Convert String to JSON
-
Functions of Mathematical Operations
- abs function
- arc cosine function
- arc sine function
- arc tan function
- arc tan2 function
- ceil function
- cosine function
- cotangent function
- degrees function
- Euler function
- exp function
- floor function
- ln function
- log function
- log10 function
- pi function
- power function
- radians function
- random function
- round function
- sign function
- sine function
- square root function
- tangent function
- truncate function
- Additional Examples
- A Introduction to the SQL for Oracle NoSQL Database Shell