ORACLE: Can I get results of "SHOW PARAMETER" into a variable or table?
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.