PL static SQL statements support direct use of SQL syntax in the statements.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Generally, PL static SQL statements use the same syntax as the following SQL statements:
SELECTstatement, which is also referred to as a query.Data manipulation language (DML) statements:
INSERT,UPDATE,DELETE, andMERGE.Transaction control language (TCL) statements:
COMMIT,ROLLBACK,SAVEPOINT,SET TRANSACTION, andLOCK TABLE.
A pseudocolumn acts like a normal column, but is not stored in a table. Static SQL statements support the following SQL pseudocolumns:
CURRVALandNEXTVALLEVELOBJECT_VALUEROWIDROWNUM