oracle-sql-parser

KO | EN

gitlite — search

#python #hacktoberfest #react #typescript #golang #go #android #rust #java #windows #cli #vue #mcp #openai

oracle-sql-parser

(★ 21)

this is a yacc (goyacc) oracle sql parser.

oracle-sql-parser 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 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
```go
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
	}
}
```

oracle-sql-parser

oracle-sql-parser 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

oracle-sql-parser

oracle-sql-parser 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README