compute sum of cnt on report : compute « SQL Plus « Oracle PL / SQL






compute sum of cnt on report

 
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> --

 








Related examples in the same category