April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: resconfs.sql
-- Purpose: Reports on all resolved conflicts.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 11-Jun-1998
--
-- Modification History
-- -------------------
-- 11-Jun-1998 : Chas. : Creation
---------------------------------------------------------------------------
col primary_key_value form a10 heading "Primary|Key"
col oname form a25 heading "Object Name"
col conflict_type form a8 heading "Conflict|Type"
col method_name form a18 heading "Resolution|Method"
col resolved_date form a15 heading "Resolution|Date"
SELECT oname,
primary_key_value,
conflict_type,
method_name,
to_char(resolved_date, 'DD-Mon HH24:MI:SS') resolved_date
FROM dba_represolution_statistics
/