DBA Data[Home] [Help]
Skip to content

VIEW: SYS.ALL_APPLY_CONFLICT_COLUMNS

Source

View Text - Preformatted

select c.object_owner, c.object_name, c.method_name,
       c.resolution_column, c.column_name, c.apply_database_link
  from all_tab_columns o, dba_apply_conflict_columns c
 where c.object_owner = o.owner
   and c.object_name = o.table_name
   and c.column_name = o.column_name
View Text - HTML Formatted

SELECT C.OBJECT_OWNER
, C.OBJECT_NAME
, C.METHOD_NAME
, C.RESOLUTION_COLUMN
, C.COLUMN_NAME
, C.APPLY_DATABASE_LINK
FROM ALL_TAB_COLUMNS O
, DBA_APPLY_CONFLICT_COLUMNS C
WHERE C.OBJECT_OWNER = O.OWNER
AND C.OBJECT_NAME = O.TABLE_NAME
AND C.COLUMN_NAME = O.COLUMN_NAME