Willson
2:51 pm on February 9, 2010 |
Answers: 1
Tags: command (40), database (51), dos (2), linux (75), oracle (138), script (27), sql (43), sqlplus (7), unix (43), windows (146) How to run/execute SQL script outside of SQLPLUS in Windows DOS command prompt
It is simple to run sql script outside of sqlplus in *nix environment. You can simple add “@scriptname.sql” at the end of the sqlplus command. However, if you need to run a sql script outside of sqlplus in Windows, you need a little trick to do it “without” the need to manually enter “exit”
How to Interact with Oracle SQLPLUS Using Windows Batch ScriptDoes Oracle SQLPLUS Issue Commit when Using Exit or Quit Command?
How to Escape Percent Character (%) in Windows Batch Script
How to Create a Windows Scheduled Task Using Script or Command LineWindows Batch Script: How to Create a Timestamp
smallwei 2:51 pm on February 9, 2010
In *nix environment, use the following command to run sql script:
sqlplus -s username/password@dbname @scriptname.sqlIn Windows DOS environment, use the following command:
echo quit | sqlplus -s username/password@dbname @scriptname.sqlRemember to replace username, password, dbname, scriptname for your need