Skip to main content

Posts

Showing posts with the label Data Dictionary table in Oracle Database

Data Dictionary and its importance in Oracle Database #DOTC_Mdb

  Data Dictionary and its importance in Oracle Database.   Today I will discuss about Data Dictionary table in Oracle Database. Data Dictionary table provide information needed by those who build systems and applications that support the data. If you know the data dictionary table names you can able to see the objects present in the database as well as also you can able to see the design , relations etc by using Data Dictionary table. Let understand about Data Dictionary first. Data Dictionary: Most important parts of an Oracle database is its data dictionary, which is a read only set of tables that provides information about the database. In Oracle database data dictionary provide useful information about the database including schema, users, privileges etc. The values in these stored dictionaries are updated automatically by Oracle anytime a statement is executed on the server that modifies the data. Note: Read-only data dictionaries can be read and queried just...