Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Hidden value vparameter.md

Created October 19, 2022 11:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Tracnac/aab6b05d982c60fc5d679386aad3ee88 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Tracnac/aab6b05d982c60fc5d679386aad3ee88 to your computer and use it in GitHub Desktop.
Download ZIP
Hidden value v$parameter #oracle #sql
Raw
Hidden value vparameter.md 
col "Parameter" for a48
col "Session Value" for a32
col "Instance Value" for a32
select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)='_'
and ksppinm like '%&1.%'
order by a.ksppinm;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment