SQL Plus - Start Command

Card Puncher Data Processing

About

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

Syntax

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

where:

Alias

Script Path Resolution

The script will be search:

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





Discover More
Card Puncher Data Processing
SQL Plus - (Arobase|At) (@ and @@)

@ is an equivalent of the START command. runs file_name.ext: from the current working directory or from the same url as the script from which it was called. Relative paths are also possible:...
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Echo

A system variable that controls whether the START command lists each command ina script as the command is executed.
Card Puncher Data Processing
SQL Plus - Script

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 with the @ or the start command where: The exit error...
Card Puncher Data Processing
SQL Plus - Special Characters

Useful command in sqlplus. The At & character is the default character that define a substitution variable. You can change it with the define system variable. The slash command (/): ...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...



Share this page:
Follow us:
Task Runner