Oracle SQL Parser

this is an oracle sql parser. ref: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf

supported statement

statement	sub statement	yacc	ast
Alter table	Add column	:heavy_check_mark:	:heavy_check_mark:
Alter table	Modify column	:heavy_check_mark:	:heavy_check_mark:
Alter table	Drop column	:heavy_check_mark:	:heavy_check_mark:
Alter table	Rename column	:heavy_check_mark:	:heavy_check_mark:
Alter table	Add constraint	:heavy_check_mark:	:heavy_check_mark:
Alter table	Modify constraint	:heavy_check_mark:	:heavy_check_mark:
Alter table	Rename constraint	:heavy_check_mark:	:heavy_check_mark:
Alter table	Drop constraint	:heavy_check_mark:	:heavy_check_mark:
Create table	Relational table	:heavy_check_mark:	:heavy_check_mark:
Create index	Relational table	:heavy_check_mark:
Drop table	-	:heavy_check_mark:	:heavy_check_mark:
Drop index	-	:heavy_check_mark:	:heavy_check_mark:

usage

package main

import (
	"fmt"
	"github.com/sjjian/oracle-sql-parser"
	"github.com/sjjian/oracle-sql-parser/ast"
)

func main() {
	stmts, err := parser.Parser("alter table db1.t1 add (id number, name varchar2(255))")
	if err != nil {
		fmt.Println(err)
		return
	}
	stmt := stmts[0]
	switch s := stmt.(type) {
	case *ast.AlterTableStmt:
		fmt.Println(s.TableName.Table.Value) // t1
	}
}