- Oracle SQL*Plus: The Definitive Guide
- Preface
- 1. Introduction to SQL*Plus
- 2. Interacting with SQL*Plus
- 3. Generating Reports with SQL*Plus
- Following a Methodology
- Saving Your Work
- Designing a Simple Report
- Advanced Report Formatting
- Totals and Subtotals
- Other Reporting Topics
- 4. Writing SQL*Plus Scripts
- Why Write Scripts?
- Using Substitution Variables
- Prompting for Values
- Cleaning Up the Display
- Packaging Your Script
- The DEFINE and UNDEFINE Commands
- Controlling Variable Substitution
- Commenting Your Scripts
- 5. Extracting and Loading Data
- 6. Exploring Your Database
- 7. Advanced Scripting
- 8. Tuning and Timing
- 9. The Product User Profile
- 10. Administration with SQL*Plus
- 11. Customizing Your SQL*Plus Environment
- SQL*Plus Settings You Can Control
- The Site and User Profiles
- Environment Variable Settings
- The SET Command
- The SHOW Command
- A. SQL*Plus Command Reference
- SQLPLUS
- Comment Delimiters (/*...*/)
- Double Hyphen (- -)
- At Sign (@)
- Double At Sign (@@)
- Forward Slash (/)
- ACCEPT
- APPEND
- ARCHIVE LOG
- ATTRIBUTE
- BREAK
- BTITLE
- CHANGE
- CLEAR
- COPY
- COLUMN
- COMPUTE
- CONNECT
- DEFINE
- DEL
- DESCRIBE
- DISCONNECT
- EDIT
- EXECUTE
- EXIT
- GET
- HELP
- HOST
- INPUT
- LIST
- PASSWORD
- PAUSE
- PROMPT
- QUIT
- RECOVER
- REMARK
- REPFOOTER
- REPHEADER
- RUN
- SAVE
- SET
- SHOW
- SHUTDOWN
- SPOOL
- START
- STARTUP
- STORE
- TIMING
- TTITLE
- UNDEFINE
- VARIABLE
- WHENEVER
- B. SQL*Plus Format Elements
- Index
- Colophon
The double at sign is used within a script file to execute another script file contained in the same directory as the first. This is very convenient if you have two scripts, one that calls the other. Use the @@ command in the first script file to call the second. Then put both files in the same directory. Now, regardless of whether or not that directory is in the search path, SQL*Plus will find the second file whenever the first calls for it. If used interactively, @@ functions exactly the same as @.
A script file is simply a text file containing SQL*Plus commands. The commands appear in the file just as you would enter them from the keyboard. See Chapter 2 for an introduction to this command. Also see the @ and START commands.
@@script_file[argument...]
where:
- @@
Is the command to execute a script file.
- script_file
Is the name of the file you want to execute, and may include the path and the extension. The default extension is SQL. The default path is the one pointing to the directory where the calling script is stored.
- argument
Is an argument you wish to pass to the script. You may pass as many arguments as you like. Arguments must be separated from each other by at least one space. Arguments may be enclosed in quotes, and should be if they contain spaces. Either single or double quotes may be used, at your discretion. Your script may reference the first argument as &1, the second as &2, and so forth.
-
No Comment