SQL Plus - Script
About
You must include:
- a semicolon at the end of each SQL command
- and a slash (/) on a new line at the end of each PL/SQL block
Articles Related
How to
Start
From the console
with the @ or the start command
From the SQL Plus utility
sqlplus login/pwd@connect_identifier @myScript MyArguments
where:
The exit error code is defined by the command whenever sqlerror and whenever oserror. Otherwise, it's always a SUCCESS.
From the cmd utility
cmd /c @echo @/mypath/myScript | sqlplus login/password@connectionString & pause
The @ symbol before a command supress the command from being echoed to the console. It's useful in situations where you don't want to turn echo off, but don't want to see the command echoed on the screen.