$ sqlplus / as sysdba SQL> set pagesize 0 SQL> set lin 200 SQL> set feed off SQL> col name for a30 SQL> col value for a60 SQL> col isdefault for a5 SQL> col description for a80 SQL> spool params.csv SQL> select '"'||isdefault||'","'||name||'","'||value||'","'||description||'"' 2 from v$parameter order by isdefault; SQL> spool off $ perl -i.org -ple 's/ +$//g' params.csv