Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query all_objects table by object_id

SQL> SQL> select owner, object_name   2  from all_objects   3  where object_id = 2408; OWNER                          OBJECT_NAME ------------------------------ ------------------------------ PUBLIC                         DBA_SYS_PRIVS SQL>