Preface

This document is intended to describe the Structured Query Language (SQL) supported by Oracle NoSQL Database. Oracle NoSQL Database can be accessed through multiple interfaces, including language SDKs and tools. SQL provides a common, declarative way to define, query, and manipulate data stored in Oracle NoSQL Database. Understanding the language is essential for designing schemas, writing efficient queries, and building reliable data access layers.

This guide begins with an introduction to SQL as implemented in Oracle NoSQL Database. It covers SQL program structure, notation conventions (including EBNF syntax), and key syntax rules for identifiers, literals, comments, operator precedence, reserved words, case sensitivity, and constraints. These topics provide a baseline for reading and writing SQL statements correctly.

The guide then explains the Oracle NoSQL Database data model, covering atomic types, complex types, JSON types, and wildcard types. Together, these types enable modeling and manipulating both structured and hierarchical data.

Building on this conceptual foundation, the remainder of the guide provides detailed syntax, semantics, and examples for the SQL operations supported by Oracle NoSQL Database.

Audience

This book is intended for developers, database designers, and users who want to write SQL statements for Oracle NoSQL Database. It serves as both a learning resource for new users and a reference manual for experienced developers.

For information about using SQL with the language SDKs to build applications, see – Developers Guide.