## MGV_ALL_CAPTURED_SQL

Columns
Grants
Dependencies
Details
Triggers

Name | Value
--- | ---
CREATED | 2011-09-19 12:29:39.0
LAST_DDL_TIME | 2011-09-19 12:29:39.0
OWNER | AREL
VIEW_NAME | MGV_ALL_CAPTURED_SQL
TEXT_LENGTH | 1162
TEXT | WITH captured_schema AS (SELECT SCHEMA_ID FROM mgv_all_schema WHERE connection_id IN (SELECT ID FROM md_connections WHERE NVL(type,'Captured') != 'CONVERTED')), captured_connections AS (SELECT ID FROM md_connections WHERE NVL(type,'Captured') != 'CONVERTED') , captured_view_trigger AS (SELECT v.trigger_id vt FROM mgv_all_view_triggers v WHERE v.connection_id IN (SELECT * FROM captured_connections)) , captured_table_trigger AS (SELECT t.trigger_id tt FROM mgv_all_table_triggers t WHERE t.connection_id IN (SELECT * FROM captured_connections)) SELECT ID,'md_stored_programs' ObjType, Name objectName, native_sql FROM md_stored_programs, captured_schema WHERE language = 'MSTSQL' AND SCHEMA_ID_FK = captured_schema.schema_id UNION ALL SELECT ID,'md_views' ObjType, view_Name objectName, native_sql FROM md_views, captured_schema WHERE language = 'MSTSQL' AND SCHEMA_ID_FK = captured_schema.schema_id UNION ALL SELECT ID,'md_triggers' ObjType, trigger_Name objectName, native_sql FROM md_triggers WHERE language = 'MSTSQL' AND (md_triggers.id in (select vt from captured_view_trigger union select tt from captured_table_trigger ))
TYPE_TEXT_LENGTH | null
TYPE_TEXT | null
OID_TEXT_LENGTH | null
OID_TEXT | null
VIEW_TYPE_OWNER | null
VIEW_TYPE | null
SUPERVIEW_NAME | null