Oracle SQL Syntax Support¶
This page documents the SQL syntax support for Oracle in the General SQL Parser.
Syntax Coverage Corpus¶
GSP tests Oracle syntax against 182 documented constructs grouped into 26 categories, each cross-referenced to the specific page in Oracle's own documentation that defines it (163 distinct source pages).
Parse coverage¶
Measured on 2026-07-25 against GSP Java 4.1.5.15, the current release. Each construct carries the complete set of examples from Oracle's documentation; a construct counts as fully covered only when every one of its examples parses.
| Constructs | Individual statements | |
|---|---|---|
| Fully parsed | 137 of 182 (75%) | 251 of 316 (79%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly.
Categories covered¶
| Category | Constructs |
|---|---|
| DROP | 49 |
| CREATE | 48 |
| ALERT | 42 |
| SELECT | 14 |
| SET | 3 |
| DML | 2 |
| FLASHBACK | 2 |
| NOAUDIT | 2 |
| TRUNCATE | 2 |
| UPDATE | 2 |
| ADMINISTER | 1 |
| ANALYZE | 1 |
| ASSOCIATE | 1 |
| AUDIT | 1 |
| CALL | 1 |
| COMMENT | 1 |
| EXPLAIN | 1 |
| GRANT | 1 |
| INSERT | 1 |
| LOCK | 1 |
| MERGE | 1 |
| PURGE | 1 |
| RENAME | 1 |
| REVOKE | 1 |
| ROLLBACK | 1 |
| SAVEPOINT | 1 |
Full construct lists are being published progressively; see Sybase, PostgreSQL or MySQL.
Key Features Supported¶
- Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
- Oracle-specific data types and functions
- PL/SQL stored procedures and packages
- Advanced analytical functions
- Hierarchical queries (CONNECT BY)
- Partitioning and advanced indexing