If you are interested in knowing which tables are present in your database, which columns they have, whether or not those columns are indexed, which privileges are granted to you, and similar information, you should query the data dictionary. Another common term for data dictionary is catalog.
DESCRIBE command; this command queries the data dictionary under the hood.
The data dictionary is more or less the internal housekeeping administration of Oracle.
The data dictionary stores information about the data, also referred to as metadata. The data dictionary is automatically maintained by Oracle; therefore, the data dictionary is always up-to-date.
No comments:
Post a Comment