Name

SET

Synopsis

SET parameter_setting

The SET command customizes 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] {15 | array_size}

Sets the number of rows SQL*Plus returns 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 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] {.|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 ...

Get Oracle SQL Plus Pocket Reference, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.