Orcale sql/plus SET command

The set command is used to set the value of a system variable. There are a number of system variables set through the SET command, and the most common ones are listed below:

　　1. ArraySize

The number of rows to be fetched at one time from the database, which defaults to 15.

Sql> show Arraysize;arraysize 15sql> set ArraySize 20; Sql> Show Arraysize;arraysize 20

2. Autcommit

　　　　is used to automatically commit when executing DML statements, which is off by default. When set to on and set to N, represents an automatic commit after an n statement or a PL/SQL statement block

1 SQL>  show autocommit; 2 OFF 3 SQL>setten; 4 SQL>  show autocommit; 5  on Ten DML statements

3. Echo

When we use start/@ to execute a script, echo controls whether to display the SQL statement that is executing in the script file. The default is off.

1 SQL>  show echo; 2 OFF

4. Feedback

When a query result set is at least n rows, the number of rows returned by the result set is displayed

1 SQL>  Show Feedback; 2 6  on

5. Heading

Whether to display column headings for query results

1 SQL>  Show Heading2 on

6. Linesize

Each line shows the number of characters, the default is 80;

1 SQL>  show linesize; 2  the

7. pagesize

Sets the number of rows to display per page, with the default value of 14.

1 SQL>  show pagesize; 2  -

8. Serveroutput

For the console to show the output of PL/SQL blocks or stored procedures, that is, when we use Dbms_output. The output of the Put_Line () is displayed on the screen. The default value is off.

1 SQL>  show Serveroutput; 2 OFF

9. Sqlprompt

The command prompt for setting sql*plus, the default value is ' sql> '.

1 SQL>  show sqlprompt; 2 sqlprompt "SQL> "

Ten. Time

Sets whether the current time of the system is displayed before the Sql*plus command prompt, and the default value is off.

1 SQL>  Show time; 2 OFF 3 SQL>seton; 4 : $: SQL >  Show time; 5  on

Timing.

Used to set whether to display the time spent executing the SQL statement, PL $. The default is off.

Orcale sql/plus SET command