SQL Plus - Script
Table of Contents
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/[email protected]_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/[email protected] & 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.