Static SQL statements

Understanding static SQL statements

Using program variables in static SQL

Table and column names in static SQL

SQL texts generated by the compiler

INSERT
Creates a new row in a database table.

UPDATE
Modifies rows of a database table.

DELETE
Removes rows from a database table.

SELECT
Produces a result set from a query on database tables.

SQL ... END SQL
Performs an SQL that is not part of the static SQL syntax.

CREATE SEQUENCE
Creates a new sequence object in the database.

ALTER SEQUENCE
Modifies the definition of an existing sequence in the database.

DROP SEQUENCE
Drops a sequence object from the database.

CREATE TABLE
Creates a new table object in the database.

ALTER TABLE
Modifies the definition of an existing table in the database.

DROP TABLE
Drops a table object from the database.

CREATE INDEX
Creates a new index object in the database.

ALTER INDEX
Modifies the definition of an existing index in the database.

DROP INDEX
Drops an index object from the database.

CREATE VIEW
Creates a new view object in the database.

DROP VIEW
Drops a view object from the database.

CREATE SYNONYM
Creates a new synonym object in the database.

DROP SYNONYM
Drops a synonym object from the database.

RENAME
Renames an object in the database.