SQL Query to check hidden parameters

select x.inst_id,x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf,
decode(bitand(ksppiflg/256,1),1,’TRUE’,’FALSE’),
decode(bitand(ksppiflg/65536,3),1,’IMMEDIATE’,2,’DEFERRED’,3,’IMMEDIATE’,’FALSE’),
decode(bitand(ksppstvf,7),1,’MODIFIED’,4,’SYSTEM_MOD’,’FALSE’),
decode(bitand(ksppstvf,2),2,’TRUE’,’FALSE’),
ksppdesc
from x$ksppi x,
x$ksppcv y
where (x.indx = y.indx)
/*and (translate(ksppinm,’_’,’#’) not like ‘#%’
or (translate(ksppinm,’_’,’#’) like ‘#%’and ksppstdf = ‘TRUE’))*/
order by 3;

Category: DatabaseSQL

Tags:

Leave a Reply

Article by: Shadab Mohammad