Compare report in excel format

 

SET MARKUP HTML ON

SPOOL  /PUM/PACKPUM38-1.html

using set pagesize 1000000

 

 Query for Project in Excel

======================================

set lines 200

set linesize 1000000

set pages 150

column Objecttype format a40

column Objectvalue1 format a20

column Objectvalue1 format a20

column sourcestatus format a20

column targetstatus format a20

select decode(objecttype, 0, 'Records',

1, 'Indexes',

2, 'Fields',

3, 'FieldFormats',

4, 'TranslateValues',

5, 'Pages',

6, 'Menus',

7, 'Components',

8, 'RecordPeoplecode',

9, 'MenuPeoplecode',

10, 'Queries',

11, 'TressStructures',

14, 'Colors',

15, 'Styles',

17, 'BusinessProcesses',

18, 'Activities',

19, 'Roles',

20, 'ProcessDefinitions',

21, 'ServerDefinitions',

22, 'ProcessTypeDefinitions',

23, 'JobDefinitions',

24, 'RecurranceDefinitions',

25, 'MessageCatalogEntries',

29, 'BusinessInterlink',

30, 'SQL',

31, 'FileLayoutDefinitions',

32, 'ComponentInterfaces',

33, 'ApplicationEnginePrograms',

34, 'ApplicationEngineSections',

35, 'MessageNodes',

36, 'Messagechannels',

37, 'Messages',

38, 'ApprovalRuleSets',

39, 'MessagePeopleCode',

40, 'SubscriptionPeoplecode',

42, 'CompInterfacePeoplecode',

43, 'ApplicationEnginePeoplecode',

44, 'PagePeoplecode',

45, 'PageFieldPeoplecode',

46, 'ComponentPeoplecode',

47, 'ComponentRecordPeoplecode',

48, 'ComponentRecFldPeoplecode',

49, 'Images',

50, 'StyleSheets',

51, 'HTML',

53, 'PermissionLists',

54, 'PortalRegistryDefinitions',

55, 'PortalRegistryStructures',

56, 'URL_Definitions',

57, 'ApplicationPackages',

58, 'App_Package_Peoplecode',

59, 'Portal Registery User Homepages',

60, 'ProblemTypes',

61, 'ArchieveTemplates',

62, 'XLAT',

63, 'Portal Registry User Favorite',

64, 'MobilePages',

65, 'Relationships',

66, 'Component_Interface_Property_PeopleCode',

67, 'Optimization_Models',

68, 'File_References',

69, 'File_Reference_TypeCode',

70, 'Archive_object_definitions',

71, 'Archive_Templates(TYPE_2)',

72, 'Diagnostic_Plug-Ins',

73, 'Analytic_Models',

79, 'Services',

80, 'Service_Operations',

81, 'Service_Operation_Handlers',

82, 'Service_Operation_Versions',

83, 'Service_Operation_Routings',

84, 'IB_Queues',

85, 'XMLP_Template_Definitions',

86, 'XMLP_Report_Definitions',

87, 'XMLP_File_Definitions',

88, 'XMLP_Data_Source_Definitions',

89, 'WSDL',

90, 'Message_Schemas',

100 , 'Essbase Cube Template',

101 , 'Delimited Document',

102 , 'Positional Document',

103 , 'Application Data Set Definition',

104 , 'Tests',

105 , 'Test Cases',

106 , 'App DataSet Binding',

107 , 'Feed',

108 , 'Feed Category',

109 , 'Feed Data Type',

110 , 'JSON Schema',

111 , 'RC Service Defn',

112 , 'RC Service',

113 , 'RC Service Config',

114 , 'RC Layout',

115 , 'Search Attribute',

116 , 'Search Definition',

117 , 'Search Category',

118 , 'Search Context',

119 , 'Integration Group',

'Others') objecttype,

Objectvalue1, objectvalue2,

decode (sourcestatus, 1, 'Absent',

2, 'Changed',

3, 'Unchanged',

4, '*Changed',

5, '*Unchanged',

6, 'Same',

'Unknown') SourceStatus,

decode (targetstatus, 1, 'Absent',

2, 'Changed',

3, 'Unchanged',

4, '*Changed',

5, '*Unchanged',

6, 'Same',

'Unknown') TargetStatus,

decode (upgradeaction, 0, 'COPY',

1, 'DELETE',

2, 'NONE',

3, 'COPYPROP') Action,

decode (takeaction, 0, 'NO',

1, 'YES',

'N/A' ) COPYFLAG, count(*) from psprojectitem where projectname = 'PACKPUM38'

group by objecttype, objectvalue1, objectvalue2, sourcestatus, targetstatus, upgradeaction, takeaction;