PL static SQL statements support direct use of SQL syntax in the statements.
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