ORACLE: Can I get results of “SHOW PARAMETER” into a variable or table


When I execute SHOW PARAMETER CONTROL_MANAGEMENT_PACK_ACCESS, it gives me the value of this Oracle parameter as part of what appears to be a single row with three columns (name, type, and value). How can I get this value into a variable or table that I can use later in my script?

I'm trying to make a decision later in my script based on a few parameter values and I'm not sure how to store them in something persistent.

Best Answer

Query v$parameter instead (or v$system_parameter in the event that you've changed session-level parameters in your current session and want to ignore those changes). show parameter is just SQL*Plus syntactic sugar on top of those data dictionary views.