Sql*Plus User’s Guide and Reference

RESTRICT Option
-R[ESTRICT] {1|2|3}
Enables you to disable certain commands that interact with the operating system. This 
is similar to disabling the same commands in the Product User Profile (PUP) table. 
However, commands disabled with the -RESTRICT option are disabled even if there is 
no connection to a server, and remain disabled until SQL*Plus terminates.
If no -RESTRICT option is active, than all commands can be used, unless disabled in 
the PUP table.
If -RESTRICT 3 is used, then LOGIN.SQL is not read. GLOGIN.SQL is read but 
restricted commands used will fail.
SILENT Option
-S[ILENT]
Suppresses all SQL*Plus information and prompt messages, including the command 
prompt, the echoing of commands, and the banner normally displayed when you start 
SQL*Plus. If you omit username or password, SQL*Plus prompts for them, but the 
prompts are not visible! Use SILENT to invoke SQL*Plus within another program so 
that the use of SQL*Plus is invisible to the user.
SILENT is a useful mode for creating reports for the web using the SQLPLUS 
-MARKUP command inside a CGI script or operating system script. The SQL*Plus 
banner and prompts are suppressed and do not appear in reports created using the 
SILENT option.
Logon
username[/password]
Represent the username and password with which you wish to start SQL*Plus and 
connect to Oracle Database. 
Table 3–1
Commands Disabled by Restriction Level
Command
Level 1
Level 2
Level 3
EDIT
disabled
disabled
disabled
GET
disabled
HOST
disabled
disabled
disabled
SAVE
disabled
disabled
SPOOL
disabled
disabled
START, @, @@
disabled
STORE
disabled
disabled

---

SQLPLUS Program Syntax
3-12
SQL*Plus User's Guide and Reference
If you omit username and password, SQL*Plus prompts you for them. If you omit 
only password, SQL*Plus prompts for it. In silent mode, username and password 
prompts are not visible! Your username appears when you type it, but not your 
password. 
@connect_identifier
Consists of an Oracle Net connect identifier. The exact syntax depends upon the 
Oracle Net configuration. For more information, refer to the Oracle Net manual or 
contact your DBA.
edition=value
The value for the Oracle Edition. An edition enables two or more versions of an object 
in a database. It provides a staging area where changed objects can be loaded into the 
database, compiled, and executed during uptime. This is particularly useful to reduce 
downtime associated with patching an application. edition=value overrides any edition 
value specified in the ORA_EDITION environment variable. For more detailed 
information, see Oracle Database Administrator's Guide.
/
Represents a default logon using operating system authentication. You cannot enter a 
connect identifier if you use a default logon. In a default logon, SQL*Plus typically 
attempts to log you in using the username OPS$name, where name is your operating 
system username. Note that the prefix "OPS$" can be set to any other string of text. For 
example, you may wish to change the settings in your INIT.ORA parameters file to 
LOGONname or USERIDname. See the Oracle Database Administrator's Guide for 
information about operating system authentication. 
AS {SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSKM}
The AS clause enables privileged connections by users who have been granted 
SYSASM, SYSBACKUP, SYSDBA, SYSDG, SYSOPER or SYSKM system privileges. For 
more detailed information, see Oracle Database Administrator's Guide.
/NOLOG
Establishes no initial connection to Oracle Database. Before issuing any SQL 
commands, you must issue a CONNECT command to establish a valid logon. Use 
/NOLOG when you want to have a SQL*Plus script prompt for the username, 
password, or database specification. The first line of this script is not assumed to 
contain a logon.
Start
@{url|file_name[.ext]} [arg ...]
Specifies the name of a script and arguments to run. The script can be called from the 
local file system or from a web server. 
SQL*Plus passes the arguments to the script as if executing the file using the SQL*Plus 
START command. If no file suffix (file extension) is specified, the suffix defined by the 
SET SUFFIX command is used. The default suffix is .sql. 
See the 
START
 command on page 12-178 for more information.