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.

  • 1
    Can you query v$parameter instead? show parameter is just SQL*Plus syntactic sugar for a query against that. – Justin Cave Mar 17 '16 at 22:15
  • @JustinCave Hmm, I sure can - I didn't realize those were synonymous (betraying my primary focus of MSSQL, not Oracle). If this were an answer, I'd accept it :) – SqlRyan Mar 17 '16 at 22:20

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.

| improve this answer | |
  • I didn't realize this was a syntax issue - thanks for pointing me to the correct system view! – SqlRyan Mar 17 '16 at 22:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.