UNIX for Dummies Questions & Answers

1. > cd /usr/your/directory
   > myscript

2. > cd /usr/your/directory
   > ./myscript

3. > /usr/your/directory/myscript

@ 
PURPOSE: 

To run the specified command file. The @ command functions similarly to START. 

SYNTAX: 


	@ file_name[.ext] [arg...]

Where: 


file_name[.ext] : is the command file you wish to run. If you omit ext, SQL*Plus assumes
the default command-file extension (usually SQL). To change the default extension, use
the SUFFIX clause of the SET command. Use @file_name or @ file_name; the space is optional.
Case may be significant in some operating environments. 

arg... : represent data items you wish to pass to parameters in the command file. If you
enter one or more arguments, SQL*Plus substitutes the values into the parameters (&1, &2,
and so forth) in the command file. The first argument replaces each occurrence of &1, the
second replaces each occurrence of &2, and so forth.

The @ command DEFINEs the parameters with the values of the arguments; if you run the
command file again in this session, you can enter new arguments or omit the arguments to
use the current values. 

Example: 
To run a command file named PRINTRPT.SQL, enter: 

SQL>  @PRINTRPT 
To run the command file WKRPT with the extension QRY, enter: 
SQL>   @WKRPT.QRY