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.
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.