DBA Data[Home] [Help]

VIEW: SYS.V_$SPPARAMETER

Source

View Text - Preformatted

select "FAMILY","SID","NAME","TYPE","VALUE","DISPLAY_VALUE","ISSPECIFIED","ORDINAL","UPDATE_COMMENT","CON_ID" from v$spparameter
View Text - HTML Formatted

SELECT "FAMILY"
, "SID"
, "NAME"
, "TYPE"
, "VALUE"
, "DISPLAY_VALUE"
, "ISSPECIFIED"
, "ORDINAL"
, "UPDATE_COMMENT"
, "CON_ID"
FROM V$SPPARAMETER