select
  INST_ID,                                 -- INST_ID NUMBER
  SID_QKSCESEROW,                          -- SID NUMBER
  PNUM_QKSCESEROW,                         -- ID NUMBER
  PNAME_QKSCESEROW,                        -- NAME VARCHAR2(40)
  FID_QKSCESEROW,                          -- SQL_FEATURE VARCHAR2(64)
  decode(                                  -- ISDEFAULT VARCHAR2(3)
    bitand(FLAGS_QKSCESEROW, 2), 0, 'NO', 'YES'),
  PVALUE_QKSCESEROW                        -- VALUE VARCHAR2(25)
from
  X$QKSCESES
where
  bitand(FLAGS_QKSCESEROW, 8) = 0 and (bitand(FLAGS_QKSCESEROW, 4) = 0 or bitand(FLAGS_QKSCESEROW, 2) = 0)