Common SET commands in ORACLE

Common SET commands in ORACLE
1 SET TIMING ON

Description: displays the SQL statement running time. The default value is OFF.

It is used in SQLPLUS and the time is accurate to 0.01 seconds. That is, 10 ms.

In PL/SQL DEVELOPER, the time is accurate to 0.001 seconds:

2 SET AUTOTRACE ON

Description: allows you to analyze executed SQL statements. The default value is OFF.

Set autotrace off: No AUTOTRACE report is generated. This is the default mode.
Set autotrace on explain: AUTOTRACE only displays the optimizer execution path report
Set autotrace on statistics: Only execution STATISTICS are displayed.
Set autotrace on: contains the execution plan and statistics
Set autotrace traceonly: Same as set autotrace on, but no query output is displayed.

3 SET TRIMOUT ON

Removes trailing spaces of each standard output line. The default value is OFF.

4 SET TRIMSPOOL ON

Remove the trailing space of the redirection (SPOOL) output line. The default value is OFF.

5 SET ECHO ON

Displays each SQL command in the START script. The default value is ON.

6 SET FEEDBACK ON

Set to display "XX rows selected"

Displays the number of records processed by this SQL command. The default value is ON.

7 set colsep''

Delimiter between output columns.

8 SET HEADING OFF

Output domain title, on by default

9 set pagesize 0

The number of output lines per page. The default value is 24. To avoid paging, you can set the value to 0.

10 set linesize 80

Output the number of characters in a row. The default value is 80.

11 set numwidth 12

Length of the output NUMBER field. The default value is 10.

12 SET TERMOUT OFF

Displays the execution results of commands in the script. The default value is ON.

13 SET SERVEROUTPUT ON

Set to allow display of output similar to DBMS_OUTPUT

Size 10000000

14 SET VERIFY OFF

You can disable or enable the display of the message "old 1" and "new 1.