DBA Data[Home] [Help]

VIEW: SYS.DBA_STREAMS_ADD_COLUMN

Source

View Text - Preformatted

select rule_owner, rule_name, schema_name, table_name, column_name,
       column_value, sys.anydata.gettypename(column_value), column_function,
       value_type, precedence, step_number
  from DBA_STREAMS_TRANSFORMATIONS
  where declarative_type = 'ADD COLUMN'
View Text - HTML Formatted

SELECT RULE_OWNER
, RULE_NAME
, SCHEMA_NAME
, TABLE_NAME
, COLUMN_NAME
, COLUMN_VALUE
, SYS.ANYDATA.GETTYPENAME(COLUMN_VALUE)
, COLUMN_FUNCTION
, VALUE_TYPE
, PRECEDENCE
, STEP_NUMBER
FROM DBA_STREAMS_TRANSFORMATIONS
WHERE DECLARATIVE_TYPE = 'ADD COLUMN'