DBA Data[Home] [Help]

VIEW: SYS.DBA_IAS_GEN_STMTS_EXP

Source

View Text - Preformatted

select ro.refresh_template_id ias_template_id,
  decode(ro.object_type, -1017, to_number(ro.object_name), 0) lineno, ddl_text
from system.repcat$_template_objects ro
where ro.object_type = -1017
View Text - HTML Formatted

SELECT RO.REFRESH_TEMPLATE_ID IAS_TEMPLATE_ID
, DECODE(RO.OBJECT_TYPE
, -1017
, TO_NUMBER(RO.OBJECT_NAME)
, 0) LINENO
, DDL_TEXT FROM SYSTEM.REPCAT$_TEMPLATE_OBJECTS RO WHERE RO.OBJECT_TYPE = -1017