Init Parms - Display non-default parms in HTML format 
--
--  Name: initparms_nondef_html.sql
--  
--  Parms: none
--
--  Description: Init Parms - Display non-default parms in HTML format
--
--  Compatability: 7.3 and above
--
--  Usage: @initparms_nondef_html
--
--  

clear columns
set feedback off heading off verify off
set lines 500 trimspool ON pages 0

define spoolfile=C:\temp\parms-nondefault.htm
define table=''

prompt spooling to file &&spoolfile
set termout off
spool &&spoolfile

prompt 

-- Define styles
prompt 

-- 
prompt 
Non default Oracle parms
 
prompt &&table

prompt 
prompt 

set wrap on
select ''||
	''
from   v$parameter
where isdefault = 'FALSE'
order by name
/
prompt 
Name Value 
'||name||
	''||value||
	'


spool off

select 'Generated on : '||to_char(sysdate,'DD-MON-YYYY') from dual ;

prompt 
spool OFF

set head on feed on term ON linesize 90