About this Content

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.

Documentation Accessibility

For information about Oracle’s commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc .

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Diversity and Inclusion

Oracle is fully committed to diversity and inclusion. Oracle respects and values having a diverse workforce that increases thought leadership and innovation. As part of our initiative to build a more inclusive culture that positively impacts our employees, customers, and partners, we are working to remove insensitive terms from our products and documentation. We are also mindful of the necessity to maintain compatibility with our customers’ existing technologies and the need to ensure continuity of service as Oracle’s offerings and industry standards evolve. Because of these technical constraints, our effort to remove insensitive terms is ongoing and will take time and external cooperation.

Related Resources

See these Oracle resources:

• Administrator’s Guide

• Concepts Guide

• Security Guide

• Developers Guide

• SQL Beginner’s Guide

Conventions

The following text conventions are used in this document:

Convention	Meaning
boldface	Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic	Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace	Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.