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 '***'
Controls automatic registration of command files using the DBMS_APPLICATION_INFO package.
Sets the number of rows that SQL*Plus will return at one time from the database when executing a query. The default is 1.
Controls whether SQL*Plus automatically commits your changes. Also specifies the number of statements to allow between each commit.
Controls whether SQL*Plus automatically prints the contents of bind variables after they have been referenced in a SQL statement or PL/SQL block.
When turned on, allows the RECOVER command to run without user intervention.
Enables and disables the automatic display of the execution plan and execution statistics for a SQL statement.
Sets the character used to terminate entry of a PL/SQL block. The default is a period.
Allows you to switch between buffers. Note that only one buffer can be used for executing SQL statements.
Controls whether SQL*Plus keeps the statement cursor open all the time.