Supported SQL statements

Devart ODBC Driver for Oracle supports a wide range of SQL statements required for most database operations. For the full syntax and a complete list of SQL statements, see the Oracle documentation.

Data Definition Language (DDL) statements

DDL statements define and manage schema objects. They typically require exclusive access to the specified object.
The supported DDL statements include:

• ALTER (all statements beginning with ALTER, except ALTER SESSION and ALTER SYSTEM)
• COMMENT
• CREATE (all statements beginning with CREATE)
• DROP (all statements beginning with DROP)
• FLASHBACK (all statements beginning with FLASHBACK)
• GRANT
• NOAUDIT
• PURGE
• RENAME
• REVOKE
• TRUNCATE

Data Manipulation Language (DML) statements

DML statements access and modify data in existing schema objects. These statements do not implicitly commit transactions.
The supported DML statements include:

• CALL
• DELETE
• EXPLAIN PLAN
• INSERT
• LOCK TABLE
• MERGE
• SELECT
• UPDATE

Transaction Control statements

Transaction control statements manage changes made by DML operations.
The supported transaction control statements include:

• COMMIT
• ROLLBACK
• SAVEPOINT
• SET TRANSACTION
• SET CONSTRAINT