title: Instead of using a lot of java code, why not send a script to DB in the form of text file?
body: <p>I was thinking that doing java code for executing DDL, DML etc is cumbersome and involves a lot of typing. So, I was thinking if databases have/can be made to have the following feature -Take a script in a text file and execute the entire script. </p>
  
  <p>If we had something like this, then we could type our SQL queries into a text file in the usual, easy way. The java code then sends this text file to the DB which executes it as if someone had typed the script into its management GUI.</p>
  
  <p>Is this possible ? What could be the disadvantages of such a system ?</p>