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:

• SQL Plus - Argument

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.