The SQL reference document provides comprehensive information on SQL syntax, execution plans, optimization techniques, system views and variables, configuration options, procedural language (PL) features, and materialized views, helping you efficiently use and manage OceanBase Database. For more details, see SQL reference.
SQL syntax
This section describes the SQL syntax supported by OceanBase Database, including Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) syntax. It also covers the MySQL and Oracle compatible SQL syntaxes, helping you write and execute SQL statements in different modes.
SQL practices and recommendations
This section provides basic SQL optimization methods and techniques, including how to improve query performance, reduce resource consumption, and avoid full table scans. It also includes common SQL optimization examples and best practices to help you enhance SQL execution efficiency in real applications.
PL reference
This section introduces the procedural language (PL) language, including its basic concepts and usage, such as stored procedures, functions, and triggers. It also covers the PL language reference for MySQL and Oracle compatible modes, helping you write and manage PL objects.
Reserved keywords (Oracle mode)
This section lists the reserved keywords in Oracle compatible mode, helping you avoid using these keywords as identifiers in your SQL statements. Reserved keywords include SELECT, INSERT, UPDATE, and DELETE.
Reserved keywords (MySQL mode)
This section lists the reserved keywords in MySQL compatible mode, helping you avoid using these keywords as identifiers in your SQL statements. Reserved keywords include SELECT, INSERT, UPDATE, and DELETE.
