VIEW: SYS.USER_MINING_MODEL_SETTINGS

Source

View Text - Preformatted

select o.name, s.name, s.value,
       decode(bitand(s.properties,1),1,'INPUT','DEFAULT')
from sys.modelset$ s, sys.obj$ o
where s.mod#=o.obj#
  and o.owner#=userenv('SCHEMAID')
  and bitand(s.properties,2) != 2

View Text - HTML Formatted

SELECT O.NAME
, S.NAME
, S.VALUE
, DECODE(BITAND(S.PROPERTIES
, 1)
, 1
, 'INPUT'
, 'DEFAULT') FROM SYS.MODELSET$ S
, SYS.OBJ$ O WHERE S.MOD#=O.OBJ#
AND O.OWNER#=USERENV('SCHEMAID')
AND BITAND(S.PROPERTIES
, 2) != 2