grammars-v4 icon indicating copy to clipboard operation
grammars-v4 copied to clipboard

sql/plsql not parsing apparently valid query string

Open kaby76 opened this issue 2 years ago • 0 comments
trafficstars

  • https://stackoverflow.com/questions/75292088/is-there-an-example-to-build-a-antlr4-grammar-parser-for-oracle-pl-sql-with-the/75295213#comment132891227_75292088
CREATE TABLE "X"."Y" ( "OID" NUMBER(19,0) NOT NULL ENABLE, "STANDARDIZED_HOME_PHONE" GENERATED ALWAYS AS (115) VIRTUAL , ) ;
CREATE TABLE "A"."B" ( "FIELD1" NUMBER(19,0) NOT NULL ENABLE, "FIELD2" NUMBER(19,0) NOT NULL ENABLE, PRIMARY KEY ("FIELD1") ENABLE ) ORGANIZATION INDEX NOCOMPRESS ; 

The only issue I noticed is that the author says "If anyone knows which SQL grammar to use , it would be greatly appreciates. Otherwise, I might have to edit or preprocess the file. – Timothy Hilgenberg". It's either plsql or it's not. How could there be any question of what server you are using?

kaby76 avatar Feb 02 '23 12:02 kaby76