I would like to run an Oracle script through SQL Plus via a Windows command prompt. The script does not contain an "exit" command, but I would still like SQL Plus to exit, returning control to the command prompt on completion of the script. My goal is to do this without modifying the script. Is this possible?
Run Oracle SQL script and exit from sqlplus.exe via command prompt
command-line-interfaceoraclesqlplus
Related Solutions
If you set the service to manual, you can create a batch file or two to start and stop it without going into the services menu. The commands would be:
net start SQLAgent$instancename
net stop SQLAgent$instancename
Example would be net start SQLAgent$MICROSOFTSMLBIZ for a BCM instance.
Similar to the agent, the server itself would be:
net start MSSQL$instancename net stop MSSQL$instancename
Related Topic
- Windows – Cannot Delete SQL Server Database via Command Line Executable
- How to run command and select core to be used
- Linux – Running SQL*Plus with bash causes wrong encoding
- Redhat – SELinux is preventing Perl CGI script from accessing Oracle libraries
- Bash – Escape all characters that shell or sqlplus need escaped in any password given
Best Answer
Another way is to use this command in the batch file: