select
  VIEW_NAME,                               -- VIEW_NAME VARCHAR2(30)
  VIEW_DEFINITION                          -- VIEW_DEFINITION VARCHAR2(4000)
from
  GV$FIXED_VIEW_DEFINITION
where
  inst_id = USERENV('Instance')