Spool derivative according to the text to set up the page number of lines to guide domain title-CodePudding

The statement is as follows:
The set pagesize 0;
Set the line 1000;
Set the heading on;
The set pagesize, 2000;
The set feedback off;
The set newp none;
Connect the ABC/pwdabc $@ ab.
Col datestr new_value filename.
Select 'G: \ backup check \' | | 'data' | | '. TXT 'datestr from dual;
Spool & amp; The filename.
@ G: \ backup check \ 1. TXT.
Spool off;
exit;

Statements set the heading on; Must want to add a page number of lines set pagesize, 2000; Will domain title export and export domain title under each field has a dotted line, should be a page break,
门店代码门店名称季节性代码季节性名称
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Help: how to remove the dotted line, or do not set the page number of rows, how to export the domain title?

CodePudding user response:

Online to find the answer, first add a line in the SQL select "title" the from dual; SPOOL inside is not setup guide domain title with Settings page rows,

CodePudding user response:

 
- this does not display the horizontal lines 
SQL> The set UND off; 
SQL> Select view_name from user_views;