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 ...