Quick Reference: SQL for NoSQL Operations

SQL for Oracle NoSQL Database serves as a high-performance, declarative language designed to bridge the gap between traditional relational patterns and modern, high-volume document storage.

This high-performance language seamlessly integrates structured tables with flexible JSON data, allowing developers to utilize familiar SQL syntax.

The following table provides a quick reference to the core SQL operations available in Oracle NoSQL Database. Use the links below to access basic operation descriptions, terminal-ready examples, and SDK API references tailored for production use cases.

Table 1 - SQL Quick Reference Table

Category	Operation	Basic Details	Syntax, Semantics, and Examples	SDK APIs/More Usecases
Namespace Management		Working with Namespaces	Namespace Management	Creating a namespace Namespace Management
Region Management		Working with Multi-Region Setup	Region Management	Creating a region Manage regions
Table Management	Create	Basic SQL Statements	Create Table Enabling Before-images During Table Creation Creating Tables With an IDENTITY Column Using the UUID data type Using the MR_COUNTER datatype Using JSON Collection Tables	Create table
	Alter		Alter Table Alter Identity Columns Add or Remove an IDENTITY column Add or Remove a UUID column Add or Remove an MR_COUNTER column	Alter Table
	Drop		Drop Table	Drop Table
Table Row Management	Insert	Adding Table Rows using INSERT and UPSERT Statements	Insert Statement Insert Rows with Identity Column Inserting rows with a UUID column Inserting rows with an MR_COUNTER column Inserting rows into JSON collection tables	Insert data
	Upsert	Adding Table Rows using INSERT and UPSERT Statements	Upsert statement	Upsert data
	Update	Modifying Table Rows using Update Statements	Update Statement Updating rows with a UUID column Updating JSON collection tables	Update Data Modify JSON data
	Delete	Basic SQL Statements	Delete Statement	Delete Data
Indexes		Working With Indexes	Indexes	Create and View Indexes Drop Index Examples of queries using index
Query Management	Selecting	Selecting columns Renaming columns Computing new columns Identifying tables and their columns Working with JSON	Select Clause From Clause	Using Query API to fetch data Using Get API to fetch data
	Filtering	Filtering results Using Exists with JSON	Where Clause	Using Query API to fetch data
	Grouping	Grouping Results	Group by Clause	Grouping results Examples using QueryRequest API
	Ordering	Ordering Results	Order by Clause	Ordering results Examples using QueryRequest API
	Limiting and Offsetting Results	Limiting and Offsetting Results	Limit Clause Offset Clause	Limit and offset results Examples using QueryRequest API
	Using External Variables	Using External Variables	Variable Declarations	Using Internal variables and aliases
Complex Data	Arrays	Working With Arrays Seeking NULLS in Arrays	Array and Map Constructors Unnest Arrays & Maps Array-Filter Step Expressions Array-Slice Step Expressions	Working with Arrays
	Records	Working with Records	Field Step Expressions Map-Filter Step Expressions	Working with nested data type
	Maps	Working With Maps	Array and Map Constructors Unnest Arrays & Maps Field Step Expressions Map-Filter Step Expressions	Working with nested data type
Expressions		Working with Expressions	Comparison Expressions Concatenation Operator Arithmetic Expressions Primary Expressions	Primary Expressions in SQL Operators in SQL
JSON Collection		Working with JSON Collection Tables	Using JSON Collection Tables Inserting rows into JSON collection tables Updating JSON collection tables	SELECT queries on JSON collection tables
GeoJSON		Working With GeoJSON Data	GeoJson Data Management	Managing GeoJSON data
Table Hierarchies	Left Outer Join	Left Outer Join		Using Left Outer joins with parent-child tables
	NESTED TABLES	NESTED TABLES		Using NESTED TABLES to join parent-child tables
	Inner Join	Inner Join		Using inner join with parent-child tables
Query Plan		Query Plan		Query execution plan
Query Optimization		Query Optimization		Tuning and Optimizing SQL queries
Built-in Functions		Built-in Functions		Timestamp functions Functions on Strings

Title and Copyright Information

SQL Quick Reference Table, Release 26.1 for Oracle Help Center

G55348-02

Copyright ©2026,

Oracle and/or its affiliates.