Static data dictionary views

USER_ / ALL_ / DBA_

Most static dictionary views come with three prefixes: USER_*, ALL_* and DBA_*. For example, there's a user_tables, all_tables and a
dba_tables view. For brevity, I only give the names of the views that
start with dba_.

dba_plsql_object_settings

dba_procedures

The column procedure_name is null for procedures and functions, it is only set for procedures and functions in pl/sql packages. The procedures' and
functions' names are found in the column object_name, however, using dba_procedures, it is not possible to find out if it is a procedure or
function. This is possible with dba_objects.