Oracle SQL Parser for Java and .NET

Example

Oracle SQL that GSP parses

CREATE OR REPLACE PACKAGE BODY hr.emp_mgmt AS
  PROCEDURE raise_salary(p_id NUMBER, p_pct NUMBER) IS
  BEGIN
    UPDATE employees SET salary = salary * (1 + p_pct / 100)
    WHERE employee_id = p_id;
  END;
END emp_mgmt;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvoracle);
parser.sqltext = sql; // the Oracle SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

The .NET edition exposes the same API in C# — see the C# quick start.

Coverage

What GSP handles in Oracle

• PL/SQL packages and types
• CONNECT BY hierarchical queries
• Synonyms and database links
• MERGE statements
• Compound triggers
• Procedural SQL: PL/SQL procedures, functions, packages, triggers, and object types, including compound triggers and pipelined functions

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for Oracle.

Actively maintained

Recent Oracle parser updates

• 2026-06-23 [Oracle] Improve synonym and dblink data lineage analysis
• 2026-06-18 [Oracle] Fix CTE alias resolution for repeated references
• 2026-06-13 [Oracle] Add regression tests for ${} in string literals

Full history in the release notes.