DBA Data[Home] [Help]

VIEW: SYS.KU$_PRE_TABLE_VIEW

Source

View Text - Preformatted

select '1','0',
          o.obj_num,
          value(o),
          sys.dbms_metadata.get_prepost_table_act
                (e.prepost, o.owner_name, o.name)
  from  sys.ku$_schemaobj_view o,
        sys.tab$ t,
        ku$_expact_view e
  where o.obj_num = t.obj#
    and e.prepost=1
    and e.owner=o.owner_name and e.name=o.name
View Text - HTML Formatted

SELECT '1'
, '0'
, O.OBJ_NUM
, VALUE(O)
, SYS.DBMS_METADATA.GET_PREPOST_TABLE_ACT (E.PREPOST
, O.OWNER_NAME
, O.NAME)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.TAB$ T
, KU$_EXPACT_VIEW E
WHERE O.OBJ_NUM = T.OBJ#
AND E.PREPOST=1
AND E.OWNER=O.OWNER_NAME
AND E.NAME=O.NAME