Mega Code Archive
Compute sum of cnt on report
<![CDATA[
SQL>
SQL> set echo on
SQL>
SQL> create table t as
2 select * from all_objects;
Table created.
SQL>
SQL> create index t_idx1 on t(object_name);
Index created.
SQL>
SQL> create index t_idx2 on t(object_type);
Index created.
SQL>
SQL> compute sum of cnt on report
SQL> break on report
SQL> select object_type, count(*) cnt from t group by object_type;
OBJECT_TYPE CNT
------------------- ----------
CONSUMER GROUP 2
INDEX PARTITION 80
SEQUENCE 110
SCHEDULE 1
TABLE PARTITION 72
RULE 4
QUEUE 2
PROCEDURE 99
OPERATOR 45
WINDOW 2
PACKAGE 727
PACKAGE BODY 685
LIBRARY 133
RULE SET 13
PROGRAM 3
LOB 1
TYPE BODY 122
CONTEXT 3
XML SCHEMA 13
TRIGGER 220
JOB CLASS 2
DIRECTORY 6
TABLE 1176
INDEX 1437
SYNONYM 2800
VIEW 2988
FUNCTION 201
WINDOW GROUP 1
INDEXTYPE 8
CLUSTER 10
TYPE 1231
EVALUATION CONTEXT 11
JOB 4
----------
sum 12212
33 rows selected.
SQL>
SQL> drop table t;
Table dropped.
SQL>
SQL> --
]]>