VIEW: XDB.RESOURCE_VIEW

Source

View Text - Preformatted

select value(p) res, abspath(8888) any_path, sys_nc_oid$ resid
  from xdb.xdb$resource p
  where under_path(value(p), '/', 8888) = 1 

View Text - HTML Formatted

SELECT VALUE(P) RES
, ABSPATH(8888) ANY_PATH
, SYS_NC_OID$ RESID
FROM XDB.XDB$RESOURCE P
WHERE UNDER_PATH(VALUE(P)
, '/'
, 8888) = 1