O'Reilly logo

Oracle SQL Plus Pocket Reference, 2nd Edition 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 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 ...

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