Crosstab_Report by aashu4uiit

VIEWS: 12 PAGES: 1

									select DECODE(GROUPING(a.owner), 1, 'All Owners', a.owner) AS "Owner", count(case when a.object_type = 'TABLE' then 1 else null end) "Tables", count(case when a.object_type = 'INDEX' then 1 else null end) "Indexes", count(case when a.object_type = 'PACKAGE' then 1 else null end) "Packages", count(case when a.object_type = 'SEQUENCE' then 1 else null end) "Sequences", count(case when a.object_type = 'TRIGGER' then 1 else null end) "Triggers", count(case when a.object_type not in ('PACKAGE','TABLE','INDEX','SEQUENCE','TRIGGER') then 1 else null end) "Other", count(case when 1 = 1 then 1 else null end) "Total" from dba_objects a group by rollup(a.owner)


								
To top