Skip to content

Instantly share code, notes, and snippets.

@Amoenus

Amoenus/apply master.bat

Created April 3, 2017 10:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Amoenus/b6ba726a008f682b1cbb84bece20eac0 to your computer and use it in GitHub Desktop.
Save Amoenus/b6ba726a008f682b1cbb84bece20eac0 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Plus script runner
Raw
apply master.bat
@echo off
echo Setting credentials
set user_name=USERNAME
echo User Name: %user_name%
set password=PASSWORD
echo Password: %password%
set net_service_name=DATABASESID
echo SID: %net_service_name%
echo running master.sql script
(
echo @master.sql
echo exit
) | sqlplus -s %user_name%/%password%@%net_service_name%
pause
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment