Name

At Sign (@)

Synopsis

@script_file [argument...]

The at sign is used to execute a SQL*Plus script file. For example:

@$ORACLE_HOME/rdbms/admin/utlxplan

@add_user "TINA" "SECRETPASSWORD"

Parameters

script_ file

Is the name of the file to execute. You may include a path as part of the name. If you do not specify a path, SQL*Plus will look in the current directory and then follow the SQL*Plus search path. The default extension is .sql.

argument

Is 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.

Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.