show parameter replacement

This is a replacement for show parameter. Ensure your SQLPATH is set.

set echo off;
set ver off;
set showm off;
column value format a50
column update_comment format a20
column description format a40 wrapped
column type format a15
column name format a35
column “Deprecated” format a11
select name,
    case type
        when 1 then ‘boolean’
        when 2 then ‘string’
        when 3 then ‘integer’
        when 4 then ‘parameter file’
        when 5 then ‘reserved’
        when 6 then ‘big integer’
        else to_char(type)
    end as type,
          isdefault as “Default?”,
          isdeprecated as “Deprecated”,
    case issys_modifiable
        when ‘IMMEDIATE’ then ‘instantly’
        when ‘DEFERRED’ then ‘init or spfile’
        when ‘FALSE’ then ‘spfile only’
        else issys_modifiable
    end as “Modifiable”
from v$parameter
where name like ‘%&1%’

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s