SQL Plus - Start Command

About

Runs the SQL*Plus statements in the specified script. The script can be called from the local file system or a web server.

Articles Related

Syntax

STA[RT] {url|file_name} [arg ...]

where:

• url supports HTTP and FTP protocols in the form: http://host.domain/script.sql
• SQL Plus - Argument

Alias

• The character specials @ can also be used to start a script.
• The character special @@ permits to start it from a relative path.
• ? means the ORACLE Home directory.

Script Path Resolution

The script will be search:

• in the working directory
• in one of the directories defined in the SQLPATH environment variable

Example

With the following test script:

Prompt Hello &1 &2 &3

• On the SQLPlus command line without quotes

start test.sql Gerard Nico !

Hello Gerard Nico !

• On the SQLPlus command line with quotes

start test.sql "GerArd Nico"  "GerNicooo oo !" "Nico !"

Hello GerArd Nico GerNicooo oo ! Nico !

Configuration

See SQL Plus - Echo