DBA Data[Home] [Help]

VIEW: SYS.DBA_STREAMS_RENAME_COLUMN

Source

View Text - Preformatted

select rule_owner, rule_name, schema_name, table_name, from_column_name,
       to_column_name, value_type, precedence, step_number
  from DBA_STREAMS_TRANSFORMATIONS
  where declarative_type = 'RENAME COLUMN'
View Text - HTML Formatted

SELECT RULE_OWNER
, RULE_NAME
, SCHEMA_NAME
, TABLE_NAME
, FROM_COLUMN_NAME
, TO_COLUMN_NAME
, VALUE_TYPE
, PRECEDENCE
, STEP_NUMBER
FROM DBA_STREAMS_TRANSFORMATIONS
WHERE DECLARATIVE_TYPE = 'RENAME COLUMN'