A simple way to run n-script sql in one command.
The following script.sh will help you launch even a great number of sql script assuming you are running oracle under a unix machine the script wants you give it the following instructions: dbuser, dbpassword, sid AND a list of the script.sql you want to launch. this script also stop and rollback on oracle error. ======= #!/bin/bash # the script asks you user pass and the db’s sid echo “user?” read user echo “pass?” read pass echo “sid?” read sid #or set the variables below #user=DBUSERHERE #pass=DBPASSWORDHERE #sid=DBSIDHERE cat