emp
This allows you to specify the type of the object you want to describe.
Server Manager now has the capability to describe both functions and procedures
contained in packages. Previously only functions and procedures not contained in
packages could be described.
Note:
Some versions of PL/SQL allow the user to describe a package by giving
the package name, and some versions require the user to specify an object in the
package to describe. Server Manager supports package description for those
versions of PL/SQL which support this functionality.
DISCONNECT
Purpose Disconnect from an Oracle server.
Prerequisites You must be currently connected to a database.
Syntax DISCONNECT command ::=
Usage Notes Upon disconnection, line mode reverts to the current default host
machine after closing all open cursors and committing any uncommitted
transactions.
Example
DISCONNECT
EXECUTE
Purpose Executes a one-line PL/SQL statement.
DBA Command Reference
B-11
EXIT
Prerequisites You must be currently connected to a database. You must also have
privileges to use any stored procedures, packages, package variables, and functions
referenced with this command.
Syntax EXECUTE command ::=
Usage Notes You can execute only one line of PL/SQL code with the EXECUTE
command. If you wish to execute a PL/SQL block with many lines, you must use
the format:
BEGIN
[PL/SQL BLOCK]
END;
You can reference any command line mode bind variables in PL/SQL statements
by preceding the variable name with a colon. The example below illustrates the use
of bind variables with the VARIABLE, EXECUTE, and PRINT commands.
Example
VARIABLE balance NUMBER
EXECUTE :balance := get_balance(34056)
PRINT balance
BALANCE
----------
4678.24
EXIT
Purpose Exits Server Manager line mode or closes a SQL Worksheet.
Prerequisites None.
Syntax EXIT command ::=
Line Mode Behavior The EXIT command leaves line mode unconditionally, commits
the current transaction, and returns to the operating system prompt.
SQL Worksheet Behavior
The EXIT command commits the current transaction and closes the worksheet.
B-12 Oracle Enterprise Manager Administrator’s Guide
RECOVER
Example
EXIT
PRINT
Purpose Print the value of a variable defined with the VARIABLE command.
Prerequisites None.
Syntax PRINT command ::=
where:
variable
The name of a variable defined by the VARIABLE command.
Usage Notes Bind variables referenced with the print command do not need to be
preceded by a colon. You can use the PRINT command to display variables defined
only in the current line mode session. The SET CHARWIDTH and SET
NUMWIDTH commands can affect the display of the PRINT command.
If no variable name is specified all currently defined variables are printed.
Examples
PRINT balance
BALANCE
----------
4687.24
SET CHARWIDTH 10
PRINT ename
ENAME
----------
SCOTT
RECOVER
Purpose Performs media recovery on one or more tablespaces, one or more
datafiles, or the entire database.
DBA Command Reference
B-13
RECOVER
Prerequisites You must be connected to the Oracle server as INTERNAL, SYSOPER,
or SYSDBA. You cannot use the RECOVER command when connected via the
multi-threaded server.
Syntax RECOVER command ::=
UNTIL clause ::=
PARALLEL clause ::=
where:
DATABASE
Specifies recovering the entire database.
USING BACKUP CONTROL FILE
Specifies that a backup of the control file is being used instead of the
current control file.
TABLESPACE tablespace
Specifies recovering a particular tablespace. Tablespace is the name of a
B-14 Oracle Enterprise Manager Administrator’s Guide
RECOVER
tablespace in the current database. You may recover up to 16 tablespaces in
one statement.
DATAFILE filename
Specifies recovering a particular datafile. You can specify any number of
datafiles.
UNTIL CANCEL
Specifies an incomplete, cancel-based recovery. Recovery proceeds by