oracle set order to introduce

May 20 posted in Oracle (RSS), 97 views.

1). Set the current session whether to modify the data automatically submitted
SQL> SET AUTO [COMMIT] (ON | OFF | IMM [EDIATE] | n)

2). Start command with the implementation of a sql script, whether the script is running the SQL statement
SQL> SET ECHO (ON | OFF)

3). Does it show the current sql statement query or modify the number of rows
SQL> SET FEED [BACK] (6 | n | ON | OFF)
By default, only the results of more than 6 lines show the results when the number of rows. If set feedback 1, regardless of the number of inquiries to the return line. When off, the query will not show the number of rows

4). Whether to display column headings
SQL> SET HEA [DING] (ON | OFF)
When the set heading off at the top of each page do not show the column headers, but instead of blank lines

5). Set his party can accommodate the number of characters
SQL> SET LIN [ESIZE] (80 | n)
If the line is greater than the output line can be set up to accommodate the number of characters, the lines are wrapped.

6). Settings page and page separation between
SQL> SET NEWP [AGE] (1 | n | NONE)
When set newpage 0, it will in the beginning of each page there is a small black box.
Set newpage n when hours will be between the pages and pages of blank lines separated by n.
When set newpage none will be in the page and there is no interval between pages.

7). Is displayed, with text values instead of NULL value
SQL> SET NULL text

8). Set up a number of rows
SQL> SET PAGES [IZE] (24 | n)
If set to 0, then all the output for the page and column headings do not show

9). It shows the output of DBMS_OUTPUT.PUT_LINE information packets.
SQL> SET SERVEROUT [PUT] (ON | OFF)
At the time of writing stored procedures, we sometimes use dbms_output.put_line will output the necessary information in order to debug stored procedure can only be set on after serveroutput variables, information can be displayed on the screen.
10) SQL> SET WRA [P] (ON | OFF)
When the output is greater than the length of the line set the length of the line (in the order set set linesize n), when set wrap on, the output line will be more than the other characters from his show, otherwise, the output of the multi-line resection of the characters will not show.

11). Whether or not the output on the screen is mainly used in conjunction with and SPOOL.
SQL> SET TERM [OUT] (ON | OFF)
Spool in order to use a large table of the contents of the output to a file, it will be the contents of the output on the screen would be a lot of time, set up after set termspool off, it will only output the contents stored in the output file will not displayed on the screen, greatly improved the speed of the spool.

12). SPOOL output to the back of each line to remove extra spaces
SQL> SET TRIMS [OUT] (ON | OFF)
13) shows that for each sql statement execution time spent
set TIMING (ON | OFF)

14). Encountered when empty do not think that statement has come to an end, from the line and then read the follow-up.
SET SQLBLANKLINES ON
Sql * plus, the sql statement does not allow intermediate time, one copy from the other parts of the script to run sql * plus very trouble. For example, the following script:
select deptno, empno, ename
from emp
where empno ='7788 ';
If the copy to run sql * plus, there will be mistakes. This command can solve the problem

15). DBMS_OUTPUT output settings
SET SERVEROUTPUT ON BUFFER 20000
Using dbms_output.put_line ( 'strin_content'); can output information in the stored procedure, stored procedure on the If you want to debug dbms_output.put_line ( 'abc'); the output appears as:
SQL> abc, instead of SQL> abc, in the SET SERVEROUTPUT ON parameters after the format wrapped.

16). The data output format html
set markup html