This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
No sql script does not run on command prompt. We can run this in sql editor or some sql tool like Toad. syntax is like this @myscript Where myscript.sql is a file which contains some sqls. Like we can execute sql queries and stored procedures from Java, can we run these scripts file also. I think my question would be more clear now.
author & internet detective
What database are you using? Many database provide a way to run scripts (list of SQL commands) from the command line. I know it is possible in Oracle, db2 and mySql. I stand by what I said before: you cannot run the script through JDBC.