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