CUBE 사용예

SQL> select owner, object_type, count(*) from dba_objects
       where owner in('SCOTT','HR','OE','PM')
       and
       object_type in('TABLE', 'VIEW', 'SEQUENCE','INDEX')
       group by cube(owner,object_type);

OWNER                                    OBJECT_TYPE           COUNT(*)
------------------------------ ------------------- ----------
                                                                                      113
                                                        VIEW                        16
                                                       INDEX                        57
                                                      TABLE                        35
                                                   SEQUENCE                     5
HR                                                                                   30
HR                                                     VIEW                         1
HR                                                    INDEX                       19
HR                                                   TABLE                        7
HR                                               SEQUENCE                     3
OE                                                                                   61

OWNER                                    OBJECT_TYPE           COUNT(*)
------------------------------ ------------------- ----------
OE                                                   VIEW                        13
OE                                                   INDEX                       31
OE                                                  TABLE                       16
OE                                               SEQUENCE                    1
PM                                                                                   6
PM                                                  INDEX                        3
PM                                                 TABLE                        3
SCOTT                                                                            16
SCOTT                                             VIEW                         2
SCOTT                                            INDEX                        4
SCOTT                                           TABLE                        9

OWNER                                     OBJECT_TYPE           COUNT(*)
------------------------------ ------------------- ----------
SCOTT                                        SEQUENCE                     1

23 개의 행이 선택되었습니다.