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 <

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *