[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