SET LINES 200 DEFINE ON VERIFY OFF FEED OFF
BREAK ON INST_ID SKIP 1
DEFINE pname=&1.
COL INST_ID HEAD "Inst" FOR 99 
COL NAME FORMAT A32 HEAD "Name"
COL VALUE FORMAT A50 TRUNC HEAD "Value"
COL ISDEFAULT HEAD "Default?" FORMAT A8
COL ISMODIFIED HEAD "Modificado?" FORMAT A11
COL ISADJUSTED HEAD "Ajustado?" FORMAT A9
COL ISDEPRECATED HEAD "Obsoleto?" FORMAT A9
COL ISSYS_MODIFIABLE HEAD "SysMod?"  FORMAT A10
COL ISSES_MODIFIABLE HEAD "SessMod?" FORMAT A10
SET LINES 330 DEFINE ON VERIFY OFF
SELECT 
  INST_ID
 ,NAME
 ,VALUE
 ,ISDEFAULT
 ,ISMODIFIED                   
 ,ISADJUSTED                   
 ,ISDEPRECATED
 ,ISSYS_MODIFIABLE                 
 ,ISSES_MODIFIABLE                 
FROM GV$PARAMETER2
WHERE UPPER(NAME) LIKE UPPER('&PNAME.')
ORDER BY INST_ID, NAME, ORDINAL
/

SET LINES 120 DEFINE ON VERIFY ON FEED 6

UNDEFINE pname 1
CLEAR BREAK