April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: repres.sql
-- Purpose: Lists all conflict resolution techniques.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
column sname heading "Schema|Name" format a8
column oname heading "Table|Name" format a25
column conflict_type heading "Conflict|Type" format a10
column method_name heading "Method" format a18
column sequence_no heading "Seq" format 99
clear breaks
break on sname on oname skip 1
SELECT sname,
substr(oname, 1, 25) oname,
conflict_type,
method_name,
sequence_no
FROM dba_represolution
ORDER BY sname, oname
/
clear breaks