Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Parameters

setting

Any one of the settings you can set using the SET command.

ALL

Shows everything, except for errors and the System Global Area (SGA).

BTI[TLE]

Displays the current page footer.

ERR[ORS]

Displays an error listing for a stored object. The command SHOW ERRORS by itself causes the error listing for the most recently created object to be displayed. You can get the error listing for a specific object by specifying the object type (function, procedure, and so forth) and the object name.

FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | TYPE | TYPE BODY | DIMENSION | JAVA CLASS

Used with SHOW ERRORS to specify the object type of interest.

[owner.] object_name

Used with SHOW ERRORS to name the object for which you want to display an error listing.

LNO

Displays the current line number.

PARAMETER[S] [ parameter_name ]

Displays the current value of one or more database initialization parameters.

PNO

Displays the current page number.

REL[EASE]

Displays the release number (the version) of the Oracle database to which you are connected.

REPF[OOTER]

Displays the current report footer.

REPH[EADER]

Displays the current report header.

SGA

Displays information about the current state of the System Global Area.

SPOO[L]

Tells you whether output is currently being spooled to a file.

SQLCODE

Displays the SQL code returned by the most recent SQL statement.

TTI[TLE]

Displays the current page title.

USER

Displays the current username.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page