batch file to open sqlplus
Posted on 2011-09-27
I have a dozens of batch files that I use to automate SQLPlus (and SQLCMD). I need to change my db passwords frequently, and updating all of my batch files is a big pain.
Could I store the pw in a single place and call it from the batch file?
Here's what a current sqlplus batch file looks like:
sqlplus user/passwrd@db @example.sql
what I'd like to have is only one file that contains my password
something like C:\securefolder\password.txt
Can I reference that in the batch file to get the pw?