O'Reilly logo

Oracle SQL*Plus Pocket Reference by Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

SET

Synopsis

SET parameter_setting

The SET command is used to customize SQL*Plus’ operations to your needs. For example:

SET DEFINE OFF
SET SERVEROUTPUT ON SIZE 1000000 -
   FORMAT WORD_WRAPPED
SET NULL '***'

Parameter Settings

SET APPI[NFO] {ON | OFF | app_text }

Controls automatic registration of command files using the DBMS_APPLICATION_INFO package.

SET ARRAY[SIZE] array_size

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

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

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] block_term_char

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required