Oracle Server Manager User's Guide

@ (at symbol)

Purpose

Run scripts containing SQL, PL/SQL, and Server Manager commands.

Prerequisites

You must have previously created the script and stored it as an operating system file.

Syntax

@ command ::=

where:

scriptname The name of an operating system file that contains a script of statements recognized by Server Manager.

Line Mode Behavior

In line mode, if you omit the scriptname argument, Server Manager prompts you for the script name.

SQL Worksheet Behavior

In a SQL Worksheet, if you omit the scriptname argument, Server Manager brings up the standard file selection dialog box for your system. You can then select the script file.

Usage Notes

This command enables you to run scripts of statements. To insert comments in the script, use the REMARK command described in "REMARK"

. To spool the output, use the SPOOL command before running or within the script. The SPOOL command is described in "SPOOL"

Do not use the @ command alone within a script unless you specify the full path name of the script.

To run other scripts from within a script, you can use the @@ command. In the original script include the line @@second_scriptname to run another script called second_scriptname. The @@ command indicates that the second script is in the same directory as the original script.

Additional Information: For information about the standard file selection dialog box for your system, see your operating system-specific documentation.