select
  INST_ID,                                 -- INST_ID NUMBER
  KQLFBC_PADD,                             -- ADDRESS RAW(8)
  KQLFBC_HASH,                             -- HASH_VALUE NUMBER
  KQLFBC_SQLID,                            -- SQL_ID VARCHAR2(13)
  KQLFBC_CADD,                             -- CHILD_ADDRESS RAW(8)
  KQLFBC_CHNO,                             -- CHILD_NUMBER NUMBER
  substr(KQLFBC_NAME, 1, 30),              -- NAME VARCHAR2(30)
  KQLFBC_POS,                              -- POSITION NUMBER
  to_number(                               -- DUP_POSITION NUMBER
    decode(KQLFBC_DUPPOS, 65535, NULL, KQLFBC_DUPPOS)),
  KQLFBC_OACDTY,                           -- DATATYPE NUMBER
  substr(KQLFBC_DTYSTR, 1, 15),            -- DATATYPE_STRING VARCHAR2(15)
  decode(                                  -- CHARACTER_SID NUMBER
    KQLFBC_OACCSI, 0, to_number(null), KQLFBC_OACCSI),
  decode(                                  -- PRECISION NUMBER
    KQLFBC_OACPRE, 0, to_number(null), KQLFBC_OACPRE),
  decode(                                  -- SCALE NUMBER
    KQLFBC_OACSCL, 0, to_number(null), KQLFBC_OACSCL),
  KQLFBC_OACMXL,                           -- MAX_LENGTH NUMBER
  decode(                                  -- WAS_CAPTURED VARCHAR2(3)
    KQLFBC_WCAP, 0, 'NO', 'YES'),
  decode(                                  -- LAST_CAPTURED DATE
    KQLFBC_WCAP, 0, to_date(NULL), decode(KQLFBC_WCAP, 2, to_date(NULL), KQLFBC_LCAP)),
  KQLFBC_STRVAL,                           -- VALUE_STRING VARCHAR2(4000)
  decode(                                  -- VALUE_ANYDATA ANYDATA
    KQLFBC_WCAP, 0, NULL, sys.sys$rawtoany(KQLFBC_BINVAL, KQLFBC_OACDTY, KQLFBC_OACCSF, KQLFBC_OACCSI)) 
from
  x$kqlfbc