Oracle SQL & PL/SQL

  DBA_OBJECTS is an Oracle data dictionary view that lists every object in the entire database — tables, views, indexes, sequences, procedures, packages, triggers, synonyms, etc. — across all schemas and all these were managed by DBA. Core Oracle database objects Object                                       Purpose      1> Table                               Stores application data in rows and columns 2> Index                             Improves query performance by providing faster access paths 3> View                               Virtual table based on a SQL query 4> Materialized View   Stores the re...