SQL> set linesize 132
SQL> column name format a30
SQL> column value format a25
SQL> select
2 x.ksppinm name,
y.ksppstvl value,
3 y.ksppstdf isdefault,
4 5 decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod,
6 decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE') isadj
7 from
8 sys.x$ksppi x,
9 sys.x$ksppcv y
10 where
11 x.inst_id = userenv('Instance') and
12 y.inst_id = userenv('Instance') and
13 x.indx = y.indx and
14 x.ksppinm like '%&par%'
15 order by
16 translate(x.ksppinm, ' _', ' ')
17 /
Enter value for par: recyclebin
old 14: x.ksppinm like '%&par%'
new 14: x.ksppinm like '%recyclebin%'
NAME VALUE ISDEFAULT ISMOD ISADJ
------------------------------ ------------------------- --------- ---------- -----
_recyclebin TRUE TRUE FALSE FALSE
1 row selected.
|