Oracle SQL Plus Pocket Reference, 2nd Edition

Name

At Sign (@)

Synopsis

@script_file [argument...]

The at sign (@) executes a SQL*Plus script file. For example:

@$ORACLE_HOME/rdbms/admin/utlxplan
@http://Gennick.com/message.sql 2

Parameters

script_file

The name, or URL in Oracle9i and higher, of the file to execute. You may include a path as part of the name. If you do not specify a path, SQL*Plus looks in the current directory and then follows the SQL*Plus search path. The default extension is .sql.

argument

An argument you wish to pass to the script. You may pass as many arguments as the script requires. Arguments must be separated from each other by at least one space.

In Oracle9i Release 1, only the Windows version of SQL*Plus allows you to identify a script file by its URL. In Release 2, all versions of SQL*Plus support this functionality. URLs may be HTTP or FTP.

In iSQL*Plus, you must specify a URL with the @ command; you cannot specify a filename.