Difference between revisions of "Init.ora"
From dbawiki
| Line 7: | Line 7: | ||
where 1=1 | where 1=1 | ||
and isdefault = 'FALSE' | and isdefault = 'FALSE' | ||
| − | and value is not null | + | and value is not null |
order by name; | order by name; | ||
</pre> | </pre> | ||
Revision as of 21:10, 10 November 2012
Show non-default parameters
set pages 100 set lines 100 select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter from v$parameter where 1=1 and isdefault = 'FALSE' and value is not null order by name;
