Oracle INFORMATION_SCHEMA: extracting metadata
June 29, 2007[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