Sorry my english is bad. I hope you can get what you want.
I have a lot of * .sql files, which I want to write a program and inform them that there is a problem (problems or mistakes).
One of my friends writes an IDE for Java, because I remember that he uses Jawak to generate the error code. On the other hand, I have automatically told IDE's Visual Studio or Netbeen that if there are errors then now I have to know how you can do this with SQL files?
In other words, I want to write an editor for a SQL files (PL / SQL) that compiles my code and tells me what is my fault.
When I try to collect all of them in SQL Plus, then this problem arises, it is very boring.
Please help me ...
SQL * plus on command line Can be run. So you can use it as a friend of your friend.
& gt; Sqlplus username / password @ connection_identifier @ scriptToExecute.sql Remember that your actions may be the result, so you might want to implement rollback for SQL and maybe for DDL / DML command Make a temporary naming
Alternatively, download the Oracle's free tool that already does everything.
Comments
Post a Comment