SELECT
  inst_id,                                 -- INST_ID NUMBER
  NFSCLIENTID,                             -- CLIENTID NUMBER
  NFSPRINCIPAL,                            -- PRINCIPAL VARCHAR2(2000)
  NFSOPAQUECLIENT,                         -- CLIENTOPAQUEIDENTIFIER VARCHAR2(1000)
  NFSVERIFIER,                             -- VERIFIER RAW(8)
  NFSLEASEEXPIRY,                          -- LEASEEXPIRY NUMBER
  NFSCLIENTNETID || NFSCLIENTADDR,         -- CLIENTADDR VARCHAR2(2000)
  decode(                                  -- CONFIRMED VARCHAR2(5)
    bitand(NFSFLAGS,1), 1, 'TRUE', 'FALSE') 
FROM
  X$NFSCLIENTS