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'
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'
|
|
|