Oracle Server Manager User's Guide
Parameters for the SQL Worksheet
The launch in context parameter for the SQL Worksheet is the COMMAND parameter. Use the COMMAND parameter to specify a statement, command, or script to execute.
The value for COMMAND:
- can be any valid SQL or PL/SQL statement, or Server Manager command
- must be enclosed in quotation marks if the command or statement contains multiple words
- must use the '@' operator to run a script
Attention: When running under Windows, you can only use the COMMAND parameter to specify a script to execute.
For example, the statement:
svrmgrm user=scott password=tiger service=t:oraserv:smtg71
subsystem=worksheet command=@utlxplan
does the following:
- starts up Server Manager in a Motif environment
- connects as SCOTT to the specified database
- opens a SQL Worksheet and runs the UTLXPLAN.SQL script
The COMMAND parameter is optional. You can specify SUBSYSTEM equals worksheet without including the COMMAND parameter. In this case, Server Manager just starts a SQL Worksheet.