Common set directives in Oracle

??

1 SET TIMING on

Description: Displays the execution time of the SQL statement. The default value is OFF.

Used in SQLPLUS , the time is accurate to 0.01 seconds. That's ten milliseconds.

In the PL/SQL DEVELOPER . Time accurate to 0.001 seconds:

2 SET AUTOTRACE on

Description: The setting agrees to parse the running SQL . The default value is OFF.

SET AUTOTRACE OFF : AUTOTRACE report is not generated. This is the default mode
SET AUTOTRACE on EXPLAIN:AUTOTRACE only displays the Optimizer run path report
SET AUTOTRACE on STATISTICS: Displays only run statistics
SET AUTOTRACEon: Includes run schedule and statistics
Set AUTOTRACE traceonly: Same set AUTOTRACEon, but does not display query output

3 SET trimout on

Remove trailing spaces per line of standard output, default to OFF

4 SET trimspool on

Remove Redirection ( SPOOL ) output trailing spaces for each line. Default is OFF

5 SET ECHO on

Show START every one of the scripts that are started SQL command, the default is on

6 SET FEEDBACK on

settings Display "Selected XX Line "

Show this time SQL the number of record bars processed by the command, by default on

7 SET colsep "

The delimiter between the output columns.

8 SET HEADING OFF

output field header, default to on

　

9 SET PAGESIZE 0

outputs the number of rows per page. The default is , in order to avoid paging. Can be set to 0.

Ten SET linesize

Output One line of characters, default is

one SET numwidth

Output Number The Type field length. The default is ten

a SET termout OFF

displays the running results of the commands in the script. The default is on

- SET serveroutput on

Set consent display output similar dbms_output

Size 10000000

- SET VERIFY OFF

ability to turn off and open prompt confirmation messages Old 1 and the New 1 the display .

Common set directives in Oracle