oracle統計某個使用者的對象個數

標籤：oracle10g   表對象統計   表   視圖   預存程序   

--統計某個使用者下面的對象個數--包括表，視圖，同義字，函數，預存程序，包，觸發器，索引,約束，序列。SELECT (SELECT COUNT(*) FROM USER_TABLES) AS TABLES,(SELECT COUNT(*) FROM USER_VIEWS)AS VIEWS,(SELECT COUNT(*) FROM USER_SYNONYMS)AS SYNONYMS,(SELECT COUNT(*)  FROM USER_OBJECTS WHERE OBJECT_TYPE=‘FUNCTION‘) AS FUNCTIONS,(SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE=‘PROCEDURE‘) AS PROCEDURES,(SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE=‘PACKAGE‘) AS PACKAGES,(SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE=‘TRIGGER‘) AS TRIGGERS,(SELECT  COUNT(*) FROM USER_INDEXES) AS INDEXES,(SELECT COUNT(*)  FROM USER_CONSTRAINTS) AS CONSTRAINTS,(SELECT COUNT(*)  FROM USER_SEQUENCES) AS SEQUENCESFROM DUAL

oracle統計某個使用者的對象個數