Filtering of sql output I want to migrate the database.
When I disable the constraints before adding the data to the output file I get extra lines:

SQL&gt; spool disable_constraints.sql;
SQL&gt; select 'alter table '||table_name||' disable constraint '||constraint_name||';' 
from all_constraints where owner = 'THE_OWNER' and constraint_name not like 'BIN%';
SQL&gt; spool off;


Part of disable_constraints.sql:

SQL&gt; select 'alter table '||table_name||' disable constraint '||constraint_name||';' from all_constraints where owner = 'THE_OWNER' and constraint_name not like 'BIN%';

    'ALTERTABLE'||TABLE_NAME||'DISABLECONSTRAINT'||CONSTRAINT_NAME||';'              
    --------------------------------------------------------------------------------
    alter table DATABASECHANGELOGLOCK disable constraint SYS_C0012929;               
    alter table DATABASECHANGELOGLOCK disable constraint SYS_C0012930;               
    alter table DATABASECHANGELOGLOCK disable constraint PK_DATABASECHANGELOGLOCK;   
    alter table DATABASECHANGELOG disable constraint SYS_C0012932;                   
    alter table DATABASECHANGELOG disable constraint SYS_C0012933;                   
    alter table DATABASECHANGELOG disable constraint SYS_C0012934;                   
    alter table DATABASECHANGELOG disable constraint SYS_C0012935;                   
    alter table DATABASECHANGELOG disable constraint SYS_C0012936;                   
    alter table DATABASECHANGELOG disable constraint SYS_C0012937;                   
    alter table ARCH_TA1_TOTAL_ENTECONOMICS disable constraint SYS_C0012938;       
    alter table ARCH_TA1_TOTAL_ENTECONOMICS disable constraint SYS_C0012939;       

    'ALTERTABLE'||TABLE_NAME||'DISABLECONSTRAINT'||CONSTRAINT_NAME||';'
    --------------------------------------------------------------------------------
    alter table ARCH_TA1_TOTAL_ENTECONOMICS disable constraint SYS_C0012940;
    alter table ARCH_TA1_TOTAL_ENTECONOMICS disable constraint SYS_C0012941;
    ....


For example, an extra line in the file:

'ALTERTABLE'||TABLE_NAME||'DISABLECONSTRAINT'||CONSTRAINT_NAME||';'              
--------------------------------------------------------------------------------


How to filter out the extra lines?
I would be very grateful for the information. Thanks to all.
For that you should configure SQL*Plus output. Documentation what can be done and how to do that is here.

In your case it is:

SET HEADING OFF