Sql Parser in C# for syntax check Oracle statements -
I want to parse the code of the C # code.
I want to check the fixed syntax of a file SQL, especially insert, update and delete delete.
Is a parser specially available which can parse the SQL code in C # .NET? Better is freeware, source code included, and easy use.
I use the Oracle
You can try with it. You will find many grammar related to Oracle.
Unrelated, is there a way to make "ready" statements without execution? This way you can have Oracle check syntax and then hold the last errors in your code. This will help you to leave the already existing duplicate functionality in Oracle. Not to mention the problem of handling changes between different versions of Oracle.
Edit: Comment again about the examples of code: I used to use ANTRR in a nutshell and I used to find a lot of code examples on the Internet It was only a difficult time. The main source I found was that I now see that the author of ARNLR, Terrence Parr, has more information in the source code.
Since you do not have much experience with ANTLR, however, I can suggest that you try another approach, because it is a very complex area and you need to learn a lot to start Required. At least, this was my experience.
Comments
Post a Comment