Query object name by object id against dba_objects : dba_objects « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_objects

Query object name by object id against dba_objects

   

SQL> select Object_Name
  2    from DBA_OBJECTS
  3   where Object_ID = 2783;
                                                              

OBJECT_NAME
------------------------------------------------------------------------------------------------------------------------
ALL_DEF_AUDIT_OPTS








Related examples in the same category

1.Query dba_objects table group by object_type
2.list table, table partition, index, index partition and lob from dba_objects
3.List all not valid database objects
4.List all sys owned package name
5.Get all system packages