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 COUN..
DataBase/Oracle
2010. 5. 18. 18:38