VIEW: SYS.KU$_EXTTAB_VIEW

Source

View Text - Preformatted

select
        et.obj#,
        et.default_dir,
        et.type$,
        et.nr_locations,
        et.reject_limit,
        et.par_type,
        et.param_clob,
        et.property,
        cast( multiset(select el.obj#, el.position, el.dir, el.name
                       from   sys.external_location$ el
                       where  el.obj# = et.obj#
                       order by el.obj#,el.position
                      ) as ku$_extloc_list_t
              )
      from sys.external_tab$ et

View Text - HTML Formatted

SELECT ET.OBJ#
, ET.DEFAULT_DIR
, ET.TYPE$
, ET.NR_LOCATIONS
, ET.REJECT_LIMIT
, ET.PAR_TYPE
, ET.PARAM_CLOB
, ET.PROPERTY
, CAST( MULTISET(SELECT EL.OBJ#
, EL.POSITION
, EL.DIR
, EL.NAME
FROM SYS.EXTERNAL_LOCATION$ EL
WHERE EL.OBJ# = ET.OBJ# ORDER BY EL.OBJ#
, EL.POSITION ) AS KU$_EXTLOC_LIST_T )
FROM SYS.EXTERNAL_TAB$ ET