Oracle INFORMATION_SCHEMA: extracting metadata

Friday Jun 29th 2007 by DatabaseJournal.com Staff
Share:

This tutorial shows how to get metadata information from an Oracle database using the Oracle Data Dictionary views.

[From Lorenzo Alberton]

While Oracle doesn't implement the INFORMATION_SCHEMA SQL-92 standard, there are several methods to get metadata information, such as using SQL *Plus and DESCRIBE, or using the the PL/SQL metadata API and the DBMS_METADATA package (available since Oracle 9i), or using the data dictionary views. In this tutorial, we're going to see how to get metadata information from our database using the Oracle Data Dictionary views ("select * from dict" for a full listing).

The article continues at http://www.alberton.info/oracle_meta_info.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved