ALL_OBJECTS view combines all types of Oracle structures into one view. : all_objects « System Tables Views « Oracle PL / SQL






ALL_OBJECTS view combines all types of Oracle structures into one view.

  

SQL> select owner, object_name, object_type, temporary
  2     from all_objects
  3     where owner in ('HR','JANICE');

OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             REGIONS
TABLE               N

HR                             REG_ID_PK
INDEX               N

HR                             COUNTRIES
TABLE               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             COUNTRY_C_ID_PK
INDEX               N

HR                             LOCATIONS
TABLE               N

HR                             LOC_ID_PK
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             LOCATIONS_SEQ
SEQUENCE            N

HR                             DEPARTMENTS
TABLE               N

HR                             DEPT_ID_PK
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             DEPARTMENTS_SEQ
SEQUENCE            N

HR                             JOBS
TABLE               N

HR                             JOB_ID_PK
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             EMPLOYEES
TABLE               N

HR                             EMP_EMAIL_UK
INDEX               N

HR                             EMP_EMP_ID_PK
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             EMPLOYEES_SEQ
SEQUENCE            N

HR                             JOB_HISTORY
TABLE               N

HR                             JHIST_EMP_ID_ST_DATE_PK
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             EMP_DETAILS_VIEW
VIEW                N

HR                             EMP_DEPARTMENT_IX
INDEX               N

HR                             EMP_JOB_IX
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             EMP_MANAGER_IX
INDEX               N

HR                             EMP_NAME_IX
INDEX               N

HR                             DEPT_LOCATION_IX
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             JHIST_JOB_IX
INDEX               N

HR                             JHIST_EMPLOYEE_IX
INDEX               N

HR                             JHIST_DEPARTMENT_IX
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             LOC_CITY_IX
INDEX               N

HR                             LOC_STATE_PROVINCE_IX
INDEX               N

HR                             LOC_COUNTRY_IX
INDEX               N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             SECURE_DML
PROCEDURE           N

HR                             SECURE_EMPLOYEES
TRIGGER             N

HR                             ADD_JOB_HISTORY
PROCEDURE           N


OWNER                          OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE         T
------------------- -
HR                             UPDATE_JOB_HISTORY
TRIGGER             N


34 rows selected.

SQL>
SQL>

   
    
  








Related examples in the same category

1.query all_objects table and subtract object_name