Query all_objects table by object_id : all_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL> select owner, object_name
  2  from all_objects
  3  where object_id = 2408;

OWNER                          OBJECT_NAME
------------------------------ ------------------------------
PUBLIC                         DBA_SYS_PRIVS

SQL>








30.10.all_objects
30.10.1.Query all_objects table by object_id
30.10.2.Query all_objects for all packages and package bodies