오라클 오브젝트

DB CAFE

추천메뉴 바로가기

DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
튜닝 { 오라클 튜닝 목록 }
모델링 { 데이터 모델링 가이드 }

1 오브젝트[편집]

1.1 사용자별 오브젝트[편집]

SELECT OWNER AS "OWNER"

         ,SUM(DECODE(OBJECT_TYPE, 'TABLE', 1, 0)) AS "TABLE"
         ,SUM(DECODE(OBJECT_TYPE, 'INDEX', 1, 0)) AS "INDEX"
         ,SUM(DECODE(OBJECT_TYPE, 'SYNONYM', 1, 0)) AS "SYNONYMS"
         ,SUM(DECODE(OBJECT_TYPE, 'SEQUENCE', 1, 0)) AS "SEQUENCES"
         ,SUM(DECODE(OBJECT_TYPE, 'VIEW', 1, 0)) AS "VIEWS"
         ,SUM(DECODE(OBJECT_TYPE, 'CLUSTER', 1, 0)) AS "CLUSTERS"
         ,SUM(DECODE(OBJECT_TYPE, 'DATABASE LINK', 1, 0)) AS "DBLINKS"
         ,SUM(DECODE(OBJECT_TYPE, 'PACKAGE', 1, 0)) AS "PACKAGES"
         ,SUM(DECODE(OBJECT_TYPE, 'PACKAGE BODY', 1, 0)) AS "PACKAGE_BODY"
         ,SUM(DECODE(OBJECT_TYPE, 'PROCEDURE', 1, 0)) AS "PROCEDURES"
         ,SUM(DECODE(OBJECT_TYPE, 'FUNCTION', 1, 0)) AS "FUNCTION"

FROM DBA_OBJECTS GROUP BY OWNER;

원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=오라클_오브젝트&oldid=2526"

Oracle