VIEW: SYS._DBA_SXGG_TRANSFORMATIONS

Source

View Text - Preformatted

select rule_owner, rule_name, 'DECLARATIVE TRANSFORMATION',
  from_schema_name, to_schema_name, from_table_name, to_table_name,
  schema_name, table_name, from_column_name, to_column_name,
  column_name, column_value, sys.anydata.gettypename(column_value),
  column_function,
  decode(value_type, 1, 'OLD',
                     2, 'NEW',
                     3, '*'),
  NULL, NULL, NULL,  decode(declarative_type, 0, 'KEEP COLUMNS',
                                              1, 'DELETE COLUMN',
                                              2, 'RENAME COLUMN',
                                              3, 'ADD COLUMN',
                                              4, 'RENAME TABLE',
                                              5, 'RENAME SCHEMA'),
  precedence, step_number
  from "_DBA_STREAMS_TRANSFORMATIONS" t
union all
select rule_owner, rule_name, 'SUBSET RULE', NULL, NULL, NULL, NULL,
  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
  decode(subsetting_operation, 1, 'INSERT',
                               2, 'UPDATE',
                               3, 'DELETE'),
  dml_condition, NULL, NULL, NULL
  from sys.streams$_rules where subsetting_operation is not NULL
union all
select rule_owner, rule_name, 'CUSTOM TRANSFORMATION', NULL, NULL, NULL, NULL,
  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
  transform_function_name, NULL, NULL, NULL, NULL, NULL
  from "_DBA_STREAMS_TRANSFM_FUNCTION"

View Text - HTML Formatted

SELECT RULE_OWNER
, RULE_NAME
, 'DECLARATIVE TRANSFORMATION'
, FROM_SCHEMA_NAME
, TO_SCHEMA_NAME
, FROM_TABLE_NAME
, TO_TABLE_NAME
, SCHEMA_NAME
, TABLE_NAME
, FROM_COLUMN_NAME
, TO_COLUMN_NAME
, COLUMN_NAME
, COLUMN_VALUE
, SYS.ANYDATA.GETTYPENAME(COLUMN_VALUE)
, COLUMN_FUNCTION
, DECODE(VALUE_TYPE
, 1
, 'OLD'
, 2
, 'NEW'
, 3
, '*')
, NULL
, NULL
, NULL
, DECODE(DECLARATIVE_TYPE
, 0
, 'KEEP COLUMNS'
, 1
, 'DELETE COLUMN'
, 2
, 'RENAME COLUMN'
, 3
, 'ADD COLUMN'
, 4
, 'RENAME TABLE'
, 5
, 'RENAME SCHEMA')
, PRECEDENCE
, STEP_NUMBER
FROM "_DBA_STREAMS_TRANSFORMATIONS" T UNION ALL SELECT RULE_OWNER
, RULE_NAME
, 'SUBSET RULE'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DECODE(SUBSETTING_OPERATION
, 1
, 'INSERT'
, 2
, 'UPDATE'
, 3
, 'DELETE')
, DML_CONDITION
, NULL
, NULL
, NULL
FROM SYS.STREAMS$_RULES
WHERE SUBSETTING_OPERATION IS NOT NULL UNION ALL SELECT RULE_OWNER
, RULE_NAME
, 'CUSTOM TRANSFORMATION'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TRANSFORM_FUNCTION_NAME
, NULL
, NULL
, NULL
, NULL
, NULL
FROM "_DBA_STREAMS_TRANSFM_FUNCTION"