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

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.


Powered by ComboStrap