Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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