Oracle PL/SQL/System Tables Views/all objects

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>

query all_objects table and subtract object_name

  
SQL>
SQL>
SQL> select substr(object_name,1,2)
  2    from all_objects t1
  3   where rownum = 1
  4  /
SU
--
IC
SQL>
SQL>