oracle-sql-parser
oracle-sql-parser copied to clipboard
Published
20 hours ago •
sjjian
sjjian
this is a yacc (goyacc) oracle sql parser.
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
}
}
sjjian