Oracle PL/SQL/System Tables Views/all objects
ALL_OBJECTS view combines all types of Oracle structures into one view.
<source lang="sql">
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>
</source>
query all_objects table and subtract object_name
<source lang="sql">
SQL> SQL> SQL> select substr(object_name,1,2)
2 from all_objects t1 3 where rownum = 1 4 /
SU -- IC SQL> SQL>
</source>
