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

SET commands

SET APPI[NFO] ( ON | OFF | app_text )

Controls automatic registration of command files using the DBMS_APPLICATION_INFO package.

SET ARRAY[SIZE] ( 15 | array_size )

Sets the number of rows that SQL*Plus will return at one time from the database when executing a query.

SET AUTO[COMMIT] (ON | OFF | IMMEDIATE | statement_count )

Controls whether SQL*Plus automatically commits your changes. Also specifies the number of statements to allow between commits.

SET AUTOP[RINT] ( ON | OFF )

Controls whether SQL*Plus automatically prints the contents of bind variables after they have been referenced in a SQL statement or PL/SQL block.

SET AUTORECOVERY (ON | OFF )

When turned on, allows the RECOVER command to run without user intervention.

SET AUTOT[RACE] (ON | OFF | TRACE[ONLY]) [EXP[LAIN]] [STAT[ISTICS]]

Enables and disables the automatic display of the execution plan and execution statistics for a SQL statement.

SET BLO[CKTERMINATOR] (. | term_char | ON | OFF)

Sets the character used to terminate entry of a PL/SQL block. The default is a period.

SET BUF[FER] ( buffer_name | SQL )

Allows you to switch between buffers. Note that only one buffer can be used for executing SQL statements.

SET CLOSECUR[SOR] (ON | OFF )

Controls whether SQL*Plus keeps the statement cursor open all the time.

SET CMDS[EP] (ON | OFF | separator_char )

Controls whether you can enter multiple SQL statements on one line and also sets the separator character. If you turn this option on, then the default separator character ...

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