15 lines
262 B
Plaintext
Executable File
15 lines
262 B
Plaintext
Executable File
set lines 180 pages 100
|
|
|
|
col p_name for a50 heading 'Parameter'
|
|
col p_value for a50 heading 'Value'
|
|
|
|
select
|
|
n.ksppinm p_name,
|
|
c.ksppstvl p_value
|
|
from
|
|
sys.x$ksppi n, sys.x$ksppcv c
|
|
where
|
|
n.indx=c.indx
|
|
and lower(n.ksppinm) like lower('\_%') escape '\'
|
|
;
|