In OceanBase Database, all operations, including O&M and data processing operations, are performed by using SQL statements.
An SQL statement is a computer language or instruction that consists of identifiers, parameters, variables, data types, and SQL reserved words.
An SQL statement must be a complete SQL sentence, such as:
SELECT last_name, department_id FROM employee;
OceanBase Database executes only complete SQL statements. For example, the following fragment will generate an error indicating that more text is required:
SELECT last_name;
In OceanBase Database, SQL statements can be divided into the following three types:
Data Definition Language (DDL) statements
Data Manipulation Language (DML) statements
Data Control Language (DCL) statements